Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RELATED in a calculated column. A calculated column is worked out once for every row of its table, so it always has a row context. RELATED fetches a value from the one side of a relationship, and it can follow several relationships in a row, for example from orders through customers to regions.
Customer Name = RELATED(customers[customer_name])
The warehouse team exports the orders table to their own system and needs the region's name on every order. The region is two relationships away: from orders to customers, then to regions.
Add the calculated column Region to orders: the name of the region the order's customer belongs to. The matrix counts [Orders] by your new column.
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