How does the AVERAGEX function (DAX) work?

Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.

AVERAGEX Formula Syntax


How do you use the AVERAGEX function?

The AVERAGEX function enables you to evaluate expressions for each row of a table, and then take the resulting set of values and calculate its arithmetic mean. Therefore, the function takes a table as its first argument, and an expression as the second argument.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the AVERAGEX function

In all other respects, AVERAGEX follows the same rules as AVERAGE. You cannot include non-numeric or null cells. Both the table and expression arguments are required.

Related Video Tutorials

Formula examples using the AVERAGEX function

=AVERAGEX(InternetSales, InternetSales[Freight]+ InternetSales[TaxAmt])

= AVERAGEX (East_Sales,East_Sales[Unit Price]*East_Sales[No. of Units])

=AVERAGEX(all(DimDate[CalendarYear]), FactSales[Sum of SalesAmount])

Related DAX Functions

Related Course Modules



To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.