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 –
FREE COURSE – Ultimate Beginners Guide To DAX –
FREE – Power BI Resources –
FREE – 60 Page DAX Reference Guide Download –
Enterprise DNA Membership –
Enterprise DNA Online –
Enterprise DNA Events –

Read More

Share This