The wrong table iterated
The task was the average value of an order line. The measure below iterates Customer, so it averages per customer instead: a much larger number.
The table you iterate sets the granularity of an average: per line, per customer, per product or per day. Pick it from the question, not from the table that “feels” right.
Your task
Fix Avg Line Value so that it returns the average of quantity times unit price per sales line.
About this exercise
You practise fix the granularity with AVERAGEX. The exercise runs on a small bike-shop model with a Sales fact table and Product, Customer and Date dimensions, the same star schema in every lesson.
Your measure, Avg Line Value, fills a Power BI-style matrix grouped by Customer[Segment] and Product[Category]. As in a real report, each cell evaluates the measure in its own filter context, and the subtotals and the grand total are evaluated again in theirs rather than added up. When you check your answer, every cell is compared with the expected value, wrong cells are marked, and the hint is about the mistake you made.
Measures that already exist in the model: Sales Amount. Reference them in square brackets, for example [Sales Amount].
Where you start
Avg Line Value = AVERAGEX(Customer, [Sales Amount])The result to build
| Category | ||||
|---|---|---|---|---|
| Segment | Accessories | Bikes | Clothing | Total |
| Business | 128.02 | 2,515.58 | 303.03 | 694.37 |
| Consumer | 56.73 | 1,347.83 | 148.23 | 365.13 |
| Total | 112.08 | 2,229.85 | 252.72 | 612.84 |
Last updated 10 November 2026
Opening the exercise…