Back to Roadmap
Level 3 — Iterators & X-Functions+75 XP
Lesson 2

2. AVERAGEX

Average customer spend or average daily revenue.

The Concept

AVERAGEX averages the result of an expression evaluated for every row of a table or entity.
Example DAX:
Avg Customer Spend = 
AVERAGEX(
    Customers,
    [Total Revenue]
)

Notice [Total Revenue] is evaluated for each customer. Context transition converts each customer row into a filter context!

Try It Yourself

Calculate average customer revenue by iterating over the Customers table with [Total Revenue].

fx
[fx]AVERAGEX=
Loading DAX Formula Studio...
Type [ for fields