Counting rows that pass a test
FILTER(table, condition) returns the rows of a table for which the condition is true. Wrapped in COUNTROWS, it counts them.
The condition is evaluated row by row, so it can use an expression like quantity times price that isn’t a column. A filter argument in CALCULATE can’t: it filters one column at a time.
Your task
Complete the measure Big Lines so that it counts the order lines worth more than 200 (quantity times unit price).
About this exercise
You practise countrows over filter with COUNTROWS and FILTER. 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, Big Lines, 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
Big Lines = COUNTROWS(FILTER(Sales, ))The result to build
| Year | |||
|---|---|---|---|
| Category | 2024 | 2025 | Total |
| Accessories | 22 | 23 | 45 |
| Bikes | 47 | 47 | 94 |
| Clothing | 21 | 19 | 40 |
| Total | 90 | 89 | 179 |
Last updated 10 November 2026
Opening the exercise…