Playground
Write any DAX you like. Save it as a measure (calculated on the fly, responds to filters) or as a calculated column (worked out once for every row of a table).
=
Ctrl/⌘ + Enter = save measure
Matrix
This works like a Power BI matrix visual. Each cell runs your measure with a different filter context. Click any cell to see which filters were applied.
Measures to show
Challenges
No auto-marking here — try each one, check your numbers in the matrix, then reveal a model answer.
The data model
A small cycle-shop business. Sales is the fact table — one row per order line. Products and Stores are lookup (dimension) tables. Filters flow from the "1" side to the "many" side, so filtering Products[Category] also filters Sales.
Cheat sheet
The DAX functions this lab understands. Click Try it to load an example into the Playground.