DAX for Power BI Part 4.2 - Sum, SumX and Other Aggregate Functions

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:

This video explains how to use DAX aggregate functions such as Sum, Average, Min and Max to aggregate a single column. You'll also learn how to use SumX, AverageX, MinX and MaxX to aggregate the results of expressions.

Chapters
00:00 Topic list
00:39 Importing Data
02:14 Basic Aggregate Functions with Measures
05:44 Aggregates without Measures
07:39 Summing the Result of a Calculation
09:05 Creating a Calculated Column
10:37 Using the SumX Function
12:28 The AverageX Function
13:31 Nesting Functions in AggregateX Functions
15:52 Referring to Columns in Other Tables

[wayneedmondson]

Hi Andrew. Really loving this series! Got a little behind and catching up now. Thanks for the great examples and explanations, along with the sample data file to follow along. Really helps to write the steps myself vs. just watching. Wise Owl is the best :)) Thumbs up!!

[MrAndyG]

Really good content, explanations and examples. Thanks so much Andrew - I can apply what I am learning immediately.

[mePrafull]

Thank you Andrew! NOw i have much better understanding of Mesures vs calculated columns in a data model

[louisyuan]

Thanks Andrew for this incredible tutorial! Just one small question here for the last example, why couldn't I establish the relationship (related to currency exchange) without creating a calculated column first please?

[algeriantechnologyconsulti]

HI, You have démonstration with exemple for Power BI and SAP HANA
Thanks

[rajkumarrajan]

Andrew, what is the difference between Related and RelatedTable?

[jeetsakharkar]

Hi Andy
Do u also have any tutorial on ML