Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Percent of total. A share divides the row's value by a total that ignores the row. Work out the total with CALCULATE and ALL on the table the rows come from, then divide with DIVIDE. On the total row nothing is filtered, so the share comes out as 1.
Region Unit Share = DIVIDE([Units], CALCULATE([Units], ALL(regions)))
The buying team plans next year's stock by how much of the business each product category carries. They want each category's share of total revenue.
Write the measure Category Share on order_items: each category's [Revenue] divided by the revenue of all categories. The total row should show 1 (100%). The matrix shows it by category 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