Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
A filter inside the measure. A visual filter only applies to that one visual. A filter inside CALCULATE travels with the measure: every visual that uses it gets the same rule. Business rules such as completed orders only belong in the measure.
Refunded Orders = CALCULATE(COUNTROWS(orders), orders[status] = "refunded")
Operations reports how many orders were actually fulfilled each quarter. Cancelled and refunded orders must not count.
Write the measure Completed Orders on orders: the number of orders whose status is completed. The matrix shows it by quarter of 2025 and has no status filter, so the measure must apply it.
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