Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Context transition in iterators. When an iterator calls a measure, the measure is worked out with the current row turned into a filter, as if it were wrapped in CALCULATE. That is how an iterator over customer IDs gets one revenue per customer. A plain expression in the same place sees no such filter.
Busiest Day Orders = MAXX(VALUES('Date'[Date]), [Orders])The sales director wants to know how much each region depends on a single customer: the revenue of its biggest customer, next to the region's total.
Write the measure Top Customer Revenue on order_items: the largest [Revenue] of any single customer, by region next to [Revenue]. Iterate over the customer IDs and use the [Revenue] measure for each one.
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe