Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ALLEXCEPT. ALLEXCEPT(table, Table[Column], …) inside CALCULATE removes every filter on the table except the columns you list. It's the shortcut when a table has many columns and you want to keep just one or two of its filters.
Segment Units = CALCULATE([Units], ALLEXCEPT(customers, customers[segment]))
The category managers review each product inside its category. Next to every product they want the revenue of the product's whole category.
Write the measure Category Revenue on order_items: [Revenue] for the product's whole category, on every product row. Use ALLEXCEPT to keep only the category filter. The matrix shows category and product 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