Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
FILTER. FILTER(table, condition) walks a table row by row and keeps the rows where the condition is true. Unlike a simple CALCULATE condition, the condition may use a measure, which is worked out for each row it walks. Pass the result to CALCULATE as a filter.
Big Product Units = CALCULATE([Units], FILTER(VALUES(products[product_id]), [Units] >= 500))
Brightline calls a customer a key account once it has brought in at least 5,000 of revenue. The sales director wants to see how much of each region's revenue comes from key accounts.
Write the measure Key Account Revenue on order_items: [Revenue] from customers whose own [Revenue] is at least 5000. Use FILTER over the customer IDs to pick them. The matrix shows it by region next to [Revenue].
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