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.
Whenever there are no rows to aggregate, the function returns a blank.
AVERAGEA manages a Boolean data type as an integer, where FALSE is 0 and TRUE is 1.
AVERAGEA always consider a string as 0, regardless of the content of the string.
It is useless to use this function in DAX with a string column because the result is always 0, resulting in a different result compared to the corresponding AVERAGEA function in Excel. In order to calculate the average of the numbers included in a column with a string data type, use AVERAGEX instead of AVERAGEA converting the column into a number using VALUE:
-- The AVERAGEA syntax does not consider the content -- of a string column (as Excel does) AVERAGEA ( table[column] ) -- The following AVERAGEX syntax works correctly -- when table[column] is a string AVERAGEX ( table, VALUE ( table[column] ) )
Other related functions are:
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://docs.microsoft.com/en-us/dax/averagea-function-dax