Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RELATEDTABLE. RELATEDTABLE(table) returns the rows of a many-side table that belong to the current row: on a customer, RELATEDTABLE(orders) is that customer's orders. Like a measure, it turns the current row into a filter and keeps the other filters, so a status filter still applies.
Popular Products = COUNTROWS(FILTER(products, COUNTROWS(RELATEDTABLE(order_items)) >= 100))
Brightline's loyalty programme invites every customer with at least 10 completed orders. Marketing wants to know how many invitations each region will send.
Write the measure Loyal Customers on customers: the number of customers with at least 10 completed orders. Use FILTER over customers and count each customer's orders with RELATEDTABLE. The matrix shows it by region for completed orders.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe