DAX Function Guide

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.

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 

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.