Combining conditions with AND
AND(a, b) is true when both tests are true; OR(a, b) when at least one is. Inside FILTER they combine a test on a column with a test on a measure.
The measure test runs per customer, through context transition, so it sees that customer’s sales in the cell.
Your task
Write Key Accounts: the number of customers in the Business segment whose Sales Amount in the cell is over 5,000.
About this exercise
You practise two tests in one filter with AND, FILTER 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, Key Accounts, fills a Power BI-style matrix grouped by Customer[Country] and Product[Category]. 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
Key Accounts =The result to build
| Category | ||||
|---|---|---|---|---|
| Country | Accessories | Bikes | Clothing | Total |
| France | 1 | 1 | 1 | 1 |
| Germany | 1 | 1 | 1 | |
| Netherlands | 1 | 1 | ||
| United Kingdom | 1 | 1 | 1 | 1 |
| Total | 3 | 4 | 2 | 4 |
Last updated 10 November 2026
Opening the exercise…