Switch Direction
DAX Practice LabSwitch Direction · Power BI training
0 of 14 lessons

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.