Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Several filters. CALCULATE takes any number of filter arguments, separated by commas, and a row must pass all of them: commas mean AND. Each simple condition may only use columns of one table, so conditions on two tables go in two arguments.
Big Online Units = CALCULATE([Units], orders[channel] = "Online", products[category] = "Cleaning")
The Mid-Market team lead pays a bonus on deals her sales reps close. She wants Mid-Market revenue from Sales Rep orders by quarter, next to total revenue.
Write the measure Mid-Market Rep Revenue on order_items: [Revenue] where customers[segment] is Mid-Market and orders[channel] is Sales Rep. The matrix shows it by quarter of 2025.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe