AVERAGEA Function (DAX)

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 Formula Syntax

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 
  • The values that evaluate to FALSE count as 0 
  • The values that contain non-numeric text count as 0 
  • Empty text (“”) counts as 0 

Related Blog Posts

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. 

Related Video Tutorials

Formula examples using the AVERAGEA function

=AVERAGEA(A2:A6)

=AVERAGEA(A2:A5,A7)

=AVERAGEA(value1, [value2], …)

Related DAX Functions

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.