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