SUM vs SUMX What is the Difference of the two DAX Functions in Power BI

Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in my courses and presentations, and people find it easy to understand. So, I thought better to explain it in a video for everyone to watch. If you want to download the sample AdventureWorksDW Excel dataset, or read the blog article, click here: https://radacad.com/sum-vs-sumx-what-is-the-difference-of-the-two-dax-functions-in-power-bi Difference between M/Power Query or DAX? https://radacad.com/m-or-dax-that-is-the-question Difference between Measure and Calculated Column in Power BI? https://radacad.com/measure-vs-calculated-column-the-mysterious-question-not Use cases of ALL function in DAX: https://radacad.com/now-you-see-me-use-cases-of-all-dax-function-in-power-bi Learn more about DAX https://radacad.com/category/dax Free Power BI Book: https://radacad.com/online-book-power-bi-from-rookie-to-rockstar