AnalystReps

DAX practice: Context Transition, Secondary Relationships & Capstone

Chapter 20 · 6 questions · included in full access

  1. Question 1 · medium

    Context transition

    What happens when a measure like [Total Sales] is evaluated inside an iterator like SUMX(Customers, ...)?

    Solve it in your browser

  2. Question 2 · hard

    By ship date

    Write Shipped Sales: total sales using the inactive relationship between Sales[ShipDate] and Calendar[Date].

    Solve it in your browser

  3. Question 3 · medium

    Count big customers

    Write Big Customers: count customers in each segment whose [Total Sales] exceeds ₹3,00,000.

    Solve it in your browser

  4. Question 4 · medium

    Best month

    Write Best Month Sales: the highest [Total Sales] achieved in any single month for each year.

    Solve it in your browser

  5. Question 5 · hard

    Target achievement

    Write Target Achieved %: divide [Total Sales] by the sum of Reps[AnnualTarget].

    Solve it in your browser

  6. Question 6 · medium

    Sales per customer

    Write Sales per Customer: divide [Total Sales] by the distinct count of CustomerID in Sales.

    Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

See pricing