DAX practice: The Star Schema & Filter Flow

Chapter 1 · 4 questions · free to solve

  1. Question 1 · easy

    Fact or dimension?

    In the practice model, which table is the fact table?

    Solve it in your browser
  2. Question 2 · easy

    Which way do filters flow?

    A table visual has Products[Category] on its rows. On the Sheets row, which tables are filtered?

    Solve it in your browser
  3. Question 3 · easy

    Total units

    Write a measure Total Units that adds up the units sold. The visual shows it by product category.

    Solve it in your browser
  4. Question 4 · easy

    Count the orders

    Write Orders: how many orders (rows of Sales) there are, by year.

    Solve it in your browser

These questions are free.

Make a free account to solve them, with instant checking and an AI tutor for hints.

Start free