How does the AVERAGEX function (DAX) work?
The AVERAGEX function (DAX) calculates the average of a set of expressions evaluated for each row of a table. It will then take the resulting set of values and calculate its arithmetic mean.
AVERAGEX Formula Syntax
How do you use the AVERAGEX function?
The function takes a table on which the aggregation is performed as its first argument, and an expression with a scalar result as its second argument.
Related Blog Posts
Related Support Forum Posts
Considerations when using the AVERAGEX function
The AVERAGEX function will not allow you to include non-numeric or null cells. Both the table and expression arguments are required.
If there are no rows that need to be averaged, the function will return a blank. If there are rows but they do not meet the criteria, the function returns 0.
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.