PL-300 practice 6: active customers
Customer success defines an active customer as one with more than 5 order lines in the period. They want the count per quarter.
The test runs per customer, in the cell’s period.
Your task
Create Active Customers: the number of customers with more than 5 order lines in the cell.
About this exercise
You practise exam-style task: counting with a measure test with COUNTROWS, FILTER and CALCULATE. 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, Active Customers, fills a Power BI-style matrix grouped by Date[Year] and Date[Quarter]. 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
Active Customers =The result to build
| Year › Quarter | Active Customers |
|---|---|
| 2024 | 9 |
| Q1 | 4 |
| Q2 | 4 |
| Q3 | 4 |
| Q4 | 3 |
| 2025 | 9 |
| Q1 | 4 |
| Q2 | 3 |
| Q3 | 4 |
| Q4 | 4 |
| Total | 9 |
Last updated 10 November 2026
Opening the exercise…