Order lines per customer
Ratios are where measures beat calculated columns: the numerator and the denominator are both evaluated in the cell’s filter context, and only then divided.
Here the numerator is the number of order lines and the denominator the number of different customers who placed them. DIVIDE returns BLANK instead of an error when a cell has no customers.
Your task
Write a measure named Lines per Customer: the number of order lines divided by the number of different customers who bought.
About this exercise
You practise a ratio of two counts with DIVIDE, COUNTROWS and DISTINCTCOUNT. 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, Lines per Customer, 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
Lines per Customer =The result to build
| Year | |||
|---|---|---|---|
| Segment | 2024 | 2025 | Total |
| Business | 39.50 | 39.50 | 79.00 |
| Consumer | 11.40 | 7.83 | 17.33 |
| Total | 23.89 | 20.50 | 42.00 |
Last updated 10 November 2026
Opening the exercise…