Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CALCULATE. CALCULATE(expression, filter) works out an expression with an extra filter added to the cell's own filters. The filter is a condition on one column, like table[column] = "value". Reusing a measure inside CALCULATE keeps its rules, such as completed orders only.
Cleaning Units = CALCULATE([Units], products[category] = "Cleaning")
The e-commerce lead wants to see, region by region, how much of Brightline's revenue came through the website, right next to total revenue.
Write the measure Online Revenue on order_items: [Revenue] from Online orders only. Use CALCULATE with a filter on orders[channel]. 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