Statistical Functions in DAX AVERAGE : Arithmetic Mean of the column values. AVERAGEA : Handles Text, Boolean and Non Numeric Data. AVERAGEX : Iterate over each row of the table and calculates Average.