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
- 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
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
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.