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

Published: 16 January 2020
on channel: Enterprise DNA
78,212
960

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/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - https://enterprisedna.co/power-bi-res...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
Working With Iterating Functions In DAX - https://blog.enterprisedna.co/working...
Using Iterating Functions SUMX And AVERAGEX In Power BI - https://blog.enterprisedna.co/using-i...
Power BI Data Model For Advanced Scenario Analysis Using DAX - https://blog.enterprisedna.co/advance...

**** Related Course Modules ****
DAX Formula Deep Dives - http://portal.enterprisedna.co/p/dax-...
Mastering DAX Calculations - http://portal.enterprisedna.co/p/mast...
Advanced DAX Combinations - http://portal.enterprisedna.co/p/adva...

**** Related Support Forum Posts ****
SUMX Vs Row By Row Multiplication - https://forum.enterprisedna.co/t/sumx...
Financial Templates Vs Last Year Make Same Period - https://forum.enterprisedna.co/t/fina...
Removing Context From SUMMARIZE - https://forum.enterprisedna.co/t/remo...
For more SUM vs SUMX support queries to review see here - https://forum.enterprisedna.co/search...


Watch video SUM vs SUMX What's The Real Difference Between These DAX Measures online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 16 January 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 78,212 times and liked it 960 visitors.