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 in a calculated column. In a calculated column on the one side of a relationship, RELATEDTABLE(table) is the many-side rows that belong to the current row, so COUNTROWS of it counts them. RELATED works the other way round: from the many side up to the one side.
Line Count = COUNTROWS(RELATEDTABLE(order_items))
Marketing wants to know whether frequent buyers spend more. They need a column on customers holding how many orders each customer has placed, so they can group revenue by it.
Add the calculated column Lifetime Orders to customers with RELATEDTABLE: how many orders the customer has placed, whatever their status. The matrix shows [Revenue] 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