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 - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/
***** Related Links *****
Working With Iterating Functions In DAX - blog.enterprisedna.co/working-with-iterating-functions-in-dax/
Using Iterating Functions SUMX And AVERAGEX In Power BI - blog.enterprisedna.co/using-iterating-functions-sumx-and-averagex-in-power-bi/
Power BI Data Model For Advanced Scenario Analysis Using DAX - blog.enterprisedna.co/advanced-scenario-analysis-techniques-for-power-bi-wdax/
***** Related Course Modules *****
DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives
Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations
Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations
***** Related Support Forum Posts *****
SUMX Vs Row By Row Multiplication - forum.enterprisedna.co/t/sumx-vs-row-by-row-multiplication/5645
Financial Templates Vs Last Year Make Same Period - forum.enterprisedna.co/t/financial-templates-vslastyear-make-sameperiod/2214/14
Removing Context From SUMMARIZE - forum.enterprisedna.co/t/removing-context-from-summarize/4674
For more SUM vs SUMX support queries to review see here - forum.enterprisedna.co/search?q=SUM%20vs%20SUMX
- SUM vs SUMX What's The Real Difference Between These DAX Measures ( Download)
- SUM vs SUMX What is the Difference of the two DAX Functions in Power BI ( Download)
- SUM, SUMX - DAX Guide ( Download)
- Power BI DAX Tutorial (5/50) - What is Sum and SumX ( Download)
- When to use SUM and SUMX in DAX ( Download)
- SUM vs SUMX in Power BI Which One Reigns Supreme for Data Analysis | DAX ( Download)
- DAX Beginners - SUM Vs SUMX in Power BI - What, When and Where ( Download)
- What is SUM & SUMX - DAX Course: 2021 #1 ( Download)
- Power BI DAX Function Sumx Tutorial | SUM vs SUMX ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Difference between SUM vs SUMX in Power BI and Power Pivot ( Download)
- How to use SUM and SUMX in Power BI // Complete Beginners Guide to Power BI in 2020 ( Download)
- SUM vs SUMX in Power BI | DAX Tutorial ( Download)
- SUM vs SUMX DAX Functions in Power BI – Simple Example ( Download)
- SUM VS SUMX SUM vs SUMX What's The Real Difference Between These DAX Functions ( Download)