Returns the average (arithmetic mean) of the values in a column. Handles text and non-numeric values.
The AVERAGEA function takes a column and averages the numbers in it, but also handles non-numeric data types transforming them to 0.
It is useless to use this function in DAX because with non-numeric columns the result is always 0.
Whenever there are no rows to aggregate, the function returns a blank.
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/averagea-function-dax