Sales from large customers
A dynamic segment is computed per cell: here, a large customer is one with at least 20,000 of sales in the cell. Sum the sales of the customers that pass.
Iterate VALUES(Customer[Customer]), keep the ones whose [Sales Amount] is at least 20,000, and add up their [Sales Amount]. The test must run per customer, so it uses the measure.
Your task
Write Large Customer Sales: the Sales Amount of customers with at least 20,000 of sales in the cell.
About this exercise
You practise dynamic segmentation with SUMX, FILTER and VALUES. 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, Large Customer Sales, fills a Power BI-style matrix grouped by Customer[Segment] 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
Large Customer Sales =The result to build
| Year | |||
|---|---|---|---|
| Segment | 2024 | 2025 | Total |
| Business | 90,916.10 | 111,534.30 | 219,420.45 |
| Consumer | |||
| Total | 90,916.10 | 111,534.30 | 219,420.45 |
Last updated 10 November 2026
Opening the exercise…