The largest order line with MAXX
Every X function works like SUMX: it walks the rows of a table, evaluates an expression for each row, and then aggregates. MAXX keeps the largest result, MINX the smallest, AVERAGEX the average.
MAX(Sales[Unit Price]) only looks at one column. The value of a line is quantity times price, which doesn’t exist as a column, so you need an iterator.
Your task
Write a measure named Largest Line that returns the value (quantity times unit price) of the largest single order line.
About this exercise
You practise iterators other than sumx with MAXX. 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, Largest Line, fills a Power BI-style matrix grouped by Customer[Country] and Date[Year]. 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
Largest Line =The result to build
| Year | |||
|---|---|---|---|
| Country | 2024 | 2025 | Total |
| France | 4,950.00 | 3,600.00 | 4,950.00 |
| Germany | 3,600.00 | 4,702.50 | 4,702.50 |
| Netherlands | 4,455.00 | 4,950.00 | 4,950.00 |
| United Kingdom | 4,950.00 | 4,950.00 | 4,950.00 |
| Total | 4,950.00 | 4,950.00 | 4,950.00 |
Last updated 10 November 2026
Opening the exercise…