Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Ranking within a group. ALL(Table[Column]) removes only the filter on that one column. In a matrix grouped by category and then product, RANKX(ALL(products[product_name]), …) drops the product filter but keeps the row's category, so each product is ranked against its own category. ALL(products) would drop both and rank across every product.
Segment Rank = IF(ISINSCOPE(customers[segment]), RANKX(ALL(customers[segment]), [Revenue]))
Each category manager wants to see which of their six products moves the most units. A company-wide rank is no use to them: the Cleaning manager wants 1 to 6 within Cleaning.
Write the measure Category Rank on order_items: each product's rank by [Units] among the products of its own category, highest first. The matrix groups by category, then product. Leave the total row blank.
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