SUM vs SUMX What's The Real Difference Between These DAX Measures

One of the key knowledge that everyone using Power BI needs to fully master is when to use SUM and SUMX. Here, I will be explaining the differences between these two DAX measures so you will know when to use SUM or SUMX when looking at a particular model.


***** Video Details *****
1:06 explaining two calculating functions: aggregating and iterating functions
2:02 using SUM as aggregating function
3:02 the difference in using SUMX as iterating function
6:21 The rule I use in choosing which function to use: aggregating or iterating function


***** 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 -

Power BI,DAX function,DAX measures,Aggregating Function,Iterating Function,SUM,SUMX,