DAX Aggregation - AVERAGEA function

Description

Returns the average (arithmetic mean) of the values in a column. Handles text and nonnumeric values.

Syntax

AVERAGEA (<column>)

Parameters

Return Value

Returns a decimal number.

Remarks

The AVERAGEA function takes a column and averages the numbers in it and handles nonnumeric data types according to the following rules −

• Values that evaluate to TRUE count as 1.
• Values that evaluate to FALSE count as 0 (zero).
• Values that contain non-numeric text count as 0 (zero).
• Empty text ("") counts as 0 (zero).

Example

= AVERAGEA (East_Sales[Sales Amount])