DAX Aggregation - AVERAGE function
Description
Returns the average (arithmetic mean) of all the numbers in a column.
Syntax
AVERAGE (<column>)
Parameters
Sr.No. | Parameter & Description |
---|---|
1 |
Column The column that contains the numbers for which you want the average. |
Return Value
Returns a decimal number that represents the arithmetic mean of the numbers in the column.
Remarks
If the column contains logical values or empty cells, those values are ignored and the rows are not counted.
Cells with the value zero are included and the rows are counted for the divisor.
Whenever there are no rows to aggregate, the function returns a blank. However, if there are rows, but none of them meet the specified criteria, the function returns 0.
Example
= AVERAGE (Sales[Sales Amount])