Finding your totals incorrect can be frustrating. Although, there is no one way to fix all totals issues, the key thing is to understand WHY your totals are incorrect. In this video, you will get to understand how context works in Power BI and I will be showing you how to iterate through tables to create a correct total.

***** Video Details *****
1:58 – creating a virtual table that calculates per row but does not provide context for the total
5:43 – using SUMX iterating function to calculate the totals
6: 37 – how SUMMARIZE iterates through every row to create correct total

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

Read More

Share This