Sales per selling day
AVERAGEX(VALUES(Date[Date]), [Sales Amount]) computes the sales of every date in the cell and averages them. Days without sales return BLANK, and AVERAGEX skips BLANK, so the result is the average per day with at least one sale.
Dividing by the number of calendar days gives a different, smaller number: the average per calendar day. Both are useful; they answer different questions.
Your task
Write a measure named Sales per Selling Day: the average Sales Amount per date that has sales.
About this exercise
You practise iterating dates, skipping blank with AVERAGEX and VALUES. 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, Sales per Selling Day, 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
Sales per Selling Day =The result to build
| Year | |||
|---|---|---|---|
| Category | 2024 | 2025 | Total |
| Accessories | 132.60 | 124.00 | 128.24 |
| Bikes | 2,274.77 | 2,437.31 | 2,355.12 |
| Clothing | 267.58 | 256.54 | 262.57 |
| Total | 813.11 | 805.82 | 809.42 |
Last updated 10 November 2026
Opening the exercise…