Counting lines with RELATEDTABLE
RELATEDTABLE(Sales) inside a row context on Product returns that product’s sales lines, within the current filter context. It is CALCULATETABLE(Sales) with context transition.
That makes questions about products answerable from the facts: how many products sold more than 10 lines in this segment and year?
Your task
Write Busy Products: the number of products with more than 10 order lines in the cell.
About this exercise
You practise from the one side to the many side with RELATEDTABLE, COUNTROWS and FILTER. 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, Busy Products, 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
Busy Products =The result to build
| Year | |||
|---|---|---|---|
| Segment | 2024 | 2025 | Total |
| Business | 5 | 5 | 8 |
| Consumer | 1 | 1 | 5 |
| Total | 8 | 8 | 8 |
Last updated 10 November 2026
Opening the exercise…