DAX practice: The SUMX Iterator
Chapter 5 · 4 questions · included in full access
Question 1 · easy
Why SUM fails here
Solve it in your browserWhy does
SUM(Sales[Units] * Sales[UnitPrice])fail in DAX?Question 2 · medium
Revenue with SUMX
Solve it in your browserWrite Revenue using SUMX: multiply Units by UnitPrice for each row of Sales, without using Line Total.
Question 3 · medium
Revenue at list price
Solve it in your browserWrite List Revenue: what Sales would have brought at the full ListPrice in Products (use SUMX and RELATED).
Question 4 · hard
Discount given
Solve it in your browserWrite Discount Given: the rupee difference between list price and actual unit price, multiplied by Units, summed over Sales.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing