Share of the top 3
How concentrated are sales? The share of the top 3 products answers it: a high share means a few products carry the business.
Put the top 3 sales in a variable and divide by the cell’s total sales.
Your task
Complete Top 3 Share: the Sales Amount of the three best-selling products divided by the cell’s Sales Amount.
About this exercise
You practise topn inside a ratio with VAR, TOPN and DIVIDE. 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, Top 3 Share, 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
Top 3 Share =
VAR Top3 = SUMX(TOPN(3, ALL(Product[Product]), [Sales Amount]), [Sales Amount])
RETURNThe result to build
| Year | |||
|---|---|---|---|
| Segment | 2024 | 2025 | Total |
| Business | 80.7% | 82.1% | 81.4% |
| Consumer | 77.3% | 86.4% | 81.6% |
| Total | 80.2% | 82.7% | 81.4% |
Last updated 10 November 2026
Opening the exercise…