01. Aggregation Functions

The foundation of DAX. Learn how to sum, count, and average data.

SUM vs SUMX
The difference between aggregating a column vs iterating a table.
👉
AVERAGE / AVERAGEA
How text and booleans affect your average calculations.
👉
MIN / MAX
Finding the highest and lowest values in a dataset.
👉
COUNT / COUNTROWS
Counting column values vs counting table rows.
👉
DISTINCTCOUNT
Counting unique values and handling duplicates.
👉
⬅ Back to DAX Menu