Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
TOPN as a filter. TOPN(n, table, order_by) returns the n rows of the table with the highest order_by values (add ASC for the lowest). Rows tied at the cut-off are all kept. The result is a table, so CALCULATE can use it as a filter: CALCULATE([m], TOPN(…)) evaluates the measure for just those rows. Rank by a measure, so each row is measured in its own filter.
Top 3 Product Units = CALCULATE([Units], TOPN(3, ALL(products[product_name]), [Units]))
Grace wants to know how much each region depends on its biggest accounts: the revenue that comes from its five largest customers, next to the region's total revenue.
Write the measure Top 5 Revenue on order_items: [Revenue] from the five customers with the highest [Revenue] in the cell. On a region row that is the region's top five; on the total row, the company's top five.
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