Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
No measure, no transition. A row context is not a filter. Inside FILTER(customers, …), a plain SUMX over order_items still sees every line in the current filters, not just the current customer's. A measure, or CALCULATE around the expression, turns the current row into a filter first.
Busy Products = COUNTROWS(FILTER(products, [Units] >= 500))
Brightline calls a customer a key account once it has brought in at least 5,000 of revenue. The AI assistant counted key accounts per region, and every single customer made the list.
AI assistant: “Key Accounts counts customers with at least 5,000 in revenue. Every customer qualifies, so the whole customer base can go into the key account programme.”
Fix Key Accounts so it counts the customers whose own [Revenue] (completed orders only) is at least 5000, 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