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