Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Remove the filter the rows set. A share needs a denominator without the row's filter. ALL only helps when it names the table or column that the rows actually filter; clearing filters on another table leaves the row's filter in place, and the row is divided by itself.
Product Share = DIVIDE([Units], CALCULATE([Units], ALL(products[product_name])))
Marketing asked for each customer segment's share of revenue. The AI assistant built Segment Share, and every segment shows 100%.
AI assistant: “Segment Share is ready. I removed the region filters so each segment is compared with the whole company. Every segment shows 100%, so each one is fully accounted for.”
Fix Segment Share so each segment's [Revenue] is divided by the revenue of all segments. The rows should add up to the total row, which shows 1 (100%).
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