DAX practice: The Star Schema & Filter Flow
Chapter 1 · 4 questions · free to solve
Question 1 · easy
Fact or dimension?
Solve it in your browserIn the practice model, which table is the fact table?
Question 2 · easy
Which way do filters flow?
Solve it in your browserA table visual has Products[Category] on its rows. On the Sheets row, which tables are filtered?
Question 3 · easy
Total units
Solve it in your browserWrite a measure Total Units that adds up the units sold. The visual shows it by product category.
Question 4 · easy
Count the orders
Solve it in your browserWrite Orders: how many orders (rows of Sales) there are, by year.
These questions are free.
Make a free account to solve them, with instant checking and an AI tutor for hints.
Start free