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