Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Filters travel down a chain. A filter flows along every relationship from the one side to the many side, one step after another. regions filters customers, customers filter orders, and orders filter every table hanging off them, refunds included. So a SUM on refunds splits by region without any extra work.
Shipments = COUNTROWS(shipments)
Customer service suspects one region refunds far more than the others and asks how much money each region has paid back.
Write the measure Refund Amount on refunds: the total amount refunded. The matrix shows it by region.
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