Calculating averages

In this section, we're going to focus on two of the DAX functions designed specifically for calculating averages: the AVERAGE and AVERAGEX functions.

The AVERAGE function

The syntax for the AVERAGE function is as follows:

AVERAGE ( <ColumnName> )

This is a very simple function that is used to calculate the average value (or the arithmetic mean) of all the numbers in a specified column. It's important to remember that this function only works with numeric values, and it cannot handle text or non-numeric values. If you want to include non-numeric values in your calculation, you will need to use the AVERAGEA function instead, which uses the same syntax as the AVERAGE function.

The AVERAGEA...