Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RANKX and ISINSCOPE. RANKX(table, expression) works out a measure for every row of the table and ranks the cell's value among the results, highest first. Rank against the full list, ALL(Table[Column]): on a row, VALUES holds only that row's value. On the total row RANKX ranks the grand total, which always comes first, so wrap it in IF(ISINSCOPE(Table[Column]), …).
Region Rank = IF(ISINSCOPE(regions[region]), RANKX(ALL(regions[region]), [Orders]))
The buying team wants a product leaderboard: every product's revenue with its rank next to it, 1 for the best seller. A rank on the total row means nothing, so it should stay empty.
Write the measure Revenue Rank on order_items: each product's rank by [Revenue] among all products, highest first. 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