## How does the AVERAGEA function (DAX) work?

This function returns the average of the values in a column. Its return value is a decimal number and it handles both text and non-numeric values.

AVERAGEA(
<column>
)

## How do you use the AVERAGEA function?

The AVERAGEA function averages the numbers in a column, and manages a Boolean data type as an integer as long as these conditions are met:

• The values that evaluates to TRUE count as 1
• Values that evaluate to FALSE count as 0
• The values that contain non-numeric text count as 0
• Empty text (“”) counts as 0

## Related Support Forum Posts

Calculating an Average of a Measure
Calculating a lifetime average and normal distribution
Grand Average total in table

## Considerations when using the AVERAGEA function

If you do not want to include logical values and text representations of numbers as part of the calculation, use the AVERAGE function instead.

If you don’t have any rows to aggregate, the AVERAGEA function returns a blank. If there is and none of them meets the specified criteria, the function returns 0.

## Formula examples using the AVERAGEA function

=AVERAGEA(A2:A6)

=AVERAGEA(A2:A5,A7)

=AVERAGEA(value1, [value2], …)

## Related Course Modules 