AVERAGE DAX Function (Aggregation)
Returns the average (arithmetic mean) of all the numbers in a column.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column that contains the numbers for which you want the average. |
Return values
Remarks
The AVERAGE function internally executes AVERAGEX, without any performance difference.
The following AVERAGE call:
AVERAGE ( table[column] )
corresponds to the following AVERAGEX call:
AVERAGEX (
table,
table[column]
)
AVERAGE ignores blank values. A value of zero is included in the average. When there are no rows to aggregate, or all the values are blank, the function returns BLANK. The column must contain numbers. With a column of type String, AVERAGE returns an error. To compute the average of an expression, use AVERAGEX.
» 2 related functions
Examples
-- AVERAGE is the short version of AVERAGEX, when used with one column only
-- In DAX, there are no differences between AVERAGEA and AVERAGE
DEFINE
MEASURE Sales[AVG Quantity 1] = AVERAGE ( Sales[Quantity] )
MEASURE Sales[AVG Quantity 2] = AVERAGEX ( Sales, Sales[Quantity] )
MEASURE Sales[AVG Line Amount] =
AVERAGEX ( Sales, Sales[Quantity] * Sales[Net Price] )
EVALUATE
SUMMARIZECOLUMNS (
'Product'[Color],
"AVG Quantity 1", [AVG Quantity 1],
"AVG Quantity 2", [AVG Quantity 2],
"AVG Line Amount", [AVG Line Amount]
)
| Color | AVG Quantity 1 | AVG Quantity 2 | AVG Line Amount |
|---|---|---|---|
| Silver | 1.40 | 1.40 | 344.49 |
| Blue | 1.41 | 1.41 | 388.00 |
| White | 1.40 | 1.40 | 266.75 |
| Red | 1.39 | 1.39 | 191.33 |
| Black | 1.40 | 1.40 | 243.68 |
| Green | 1.40 | 1.40 | 652.64 |
| Orange | 1.40 | 1.40 | 543.64 |
| Pink | 1.40 | 1.40 | 235.54 |
| Yellow | 1.42 | 1.42 | 47.90 |
| Purple | 1.36 | 1.36 | 79.65 |
| Brown | 1.40 | 1.40 | 559.52 |
| Grey | 1.40 | 1.40 | 411.63 |
| Gold | 1.41 | 1.41 | 365.89 |
| Azure | 1.37 | 1.37 | 244.70 |
| Silver Grey | 1.42 | 1.42 | 550.98 |
| Transparent | 1.40 | 1.40 | 3.68 |
More examples available for the AVERAGEX function.
Related articles
Learn more about AVERAGE in the following articles:
-
Using tuple syntax in DAX expressions
This article describes the use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns. » Read more
-
Introducing EXPAND and COLLAPSE for visual calculations in Power BI
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. » Read more
Related functions
Other related functions are:
Last update: Oct 21, 2026 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/average-function-dax