Two filters on one column
The measure should return the sales of bikes and clothing together, but every cell is empty. Two filter arguments in CALCULATE are combined with AND: no product is a bike and clothing at the same time.
To allow several values of one column, use one filter with IN { … } or ||.
Your task
Fix Bikes and Clothing so that it returns the Sales Amount of bikes plus clothing.
About this exercise
You practise fix filters that cancel out with CALCULATE and IN. 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, Bikes and Clothing, fills a Power BI-style matrix grouped by Customer[Country] 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
Bikes and Clothing = CALCULATE([Sales Amount], Product[Category] = "Bikes", Product[Category] = "Clothing")The result to build
| Year | |||
|---|---|---|---|
| Country | 2024 | 2025 | Total |
| France | 28,014.00 | 20,485.95 | 48,499.95 |
| Germany | 33,493.70 | 47,623.90 | 81,117.60 |
| Netherlands | 19,877.95 | 25,582.25 | 45,460.20 |
| United Kingdom | 32,217.35 | 22,528.45 | 54,745.80 |
| Total | 113,603.00 | 116,220.55 | 229,823.55 |
Last updated 10 November 2026
Opening the exercise…