Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SWITCH. SWITCH(value, match1, result1, match2, result2, …, else) returns the result paired with the first match. Leave out the else and it returns blank when nothing matches. Paired with SELECTEDVALUE, it turns the single value on a row into a number.
Region Bonus = SWITCH(SELECTEDVALUE(regions[region]), "East", 500, "West", 300, 0)
Finance pays commission by sales channel: 5% on Sales Rep orders, 8% on Partner orders and 0% on Online orders. They want the rate next to each channel's revenue so the payout can be checked.
Write the measure Commission Rate on orders: 0.05 for Sales Rep, 0.08 for Partner and 0 for Online, read from the channel of the row. The total row mixes channels, so it should stay blank.
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