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


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 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(value1, [value2], …)

Related DAX Functions


Related Course Modules



Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.

Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide