Customers without sales
Customers who bought nothing in a period have no rows in Sales. The measure below looks for them in Sales, where they can’t be: it always returns BLANK.
To find what is missing, iterate the dimension (Customer) and test the measure for each item. ISBLANK([Sales Amount]) is true for customers without sales in the cell.
Your task
Fix No-Sale Customers so that it counts the customers without any sales in the cell.
About this exercise
You practise fix: what isn’t in the facts with FILTER, ISBLANK and COUNTROWS. 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, No-Sale Customers, fills a Power BI-style matrix grouped by Product[Category] 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
No-Sale Customers = COUNTROWS(FILTER(Sales, ISBLANK(Sales[Quantity])))The result to build
| Year | |||
|---|---|---|---|
| Category | 2024 | 2025 | Total |
| Accessories | 1 | 1 | 1 |
| Bikes | 2 | 1 | |
| Clothing | 1 | 2 | 1 |
| Total | 1 | ||
Last updated 10 November 2026
Opening the exercise…