Back to Roadmap
Level 1 — DAX Foundations+50 XP
Lesson 6
6. AVERAGE
Calculating the arithmetic mean of a column.
The Concept
AVERAGE returns the mean of all numerical values in a column, automatically skipping nulls/blanks.
Example DAX:
Avg Sale Revenue = AVERAGE(Sales[Revenue])
Remember that AVERAGE only works across rows in a single column. It divides the sum of non-blank values by the count of non-blank values.
Try It Yourself
Create a measure 'Avg Revenue' calculating the average of Sales[Revenue].
fx
[fx]AVERAGE=
Loading DAX Formula Studio...
Type [ for fields