DAX Function Guide

AVERAGEX
Empty image or helper icon

Sam McKay

CEO & Founder

How does the AVERAGEX 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

AVERAGEX(
     <table>,<expression>
)

How do you use the AVERAGEX?

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

Loading

Considerations when using the AVERAGEX?

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

Loading

Formula examples using the AVERAGEX

=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 Courses

Loading