Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Finance pays 5% commission on Sales Rep revenue, 8% on Partner revenue and nothing on Online revenue. The AI assistant built a Commission measure for the regional payout sheet, and every region shows 0.
AI assistant: “Commission is done: Revenue times the channel rate from a SWITCH. All regions come out at 0, so it looks like no commission is due this year.”
Fix Commission so each region shows its commission: each channel's revenue in that region times the channel's rate, added up. The total row should be the company-wide commission.
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