DAX function
AVERAGE — DAX function reference
Mean of a column.
Syntax
dax
AVERAGE(<column>)
Examples
dax
AVERAGE(Sales[Amount])
→ A number
dax
CALCULATE(AVERAGE(Sales[Amount]), Sales[Channel] = "Online")
→ Average online order value
dax
VAR OrderAvg = AVERAGE(Sales[Amount]) VAR OverallAvg = CALCULATE(AVERAGE(Sales[Amount]), ALL(Sales)) RETURN OrderAvg - OverallAvg
→ How far this context's average is from the overall average
Common mistakes & gotchas
- AVERAGE ignores blank cells (they do not count toward the denominator) and only works on a physical numeric column — for a computed per-row average, use AVERAGEX.
Related DAX functions
From Aggregations