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

# Calculating averages

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