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

Learn the difference between SUM vs SUMX in Power BI and how to figure out which function to choose in different scenarios. ***** Video Details ***** 1:01 - aggregating vs iterating functions 2:02 - SUM as an aggregating function 3:01 - SUMX as an iterating function 5:46 - deciding between SUM vs SUMX ***** 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 - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-reference-guide-download FREE - Power BI Resources - https://enterprisedna.co/power-bi-resources Enterprise DNA Membership - https://enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Working With Iterating Functions In DAX - https://blog.enterprisedna.co/working-with-iterating-functions-in-dax/ Using Iterating Functions SUMX And AVERAGEX In Power BI - https://blog.enterprisedna.co/using-iterating-functions-sumx-and-averagex-in-power-bi/ Power BI Data Model For Advanced Scenario Analysis Using DAX - https://blog.enterprisedna.co/advanced-scenario-analysis-techniques-for-power-bi-wdax/ ***** Related Course Modules ***** DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-formula-deep-dives Mastering DAX Calculations - http://portal.enterprisedna.co/p/mastering-dax-calculations Advanced DAX Combinations - http://portal.enterprisedna.co/p/advanced-dax-combinations ***** Related Support Forum Posts ***** SUMX Vs Row By Row Multiplication - https://forum.enterprisedna.co/t/sumx-vs-row-by-row-multiplication/5645 Financial Templates Vs Last Year Make Same Period - https://forum.enterprisedna.co/t/financial-templates-vslastyear-make-sameperiod/2214/14 Removing Context From SUMMARIZE - https://forum.enterprisedna.co/t/removing-context-from-summarize/4674 For more SUM vs SUMX support queries to review see here - https://forum.enterprisedna.co/search?q=SUM%20vs%20SUMX