Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Expanded tables. A table in DAX carries the tables it reaches through many-to-one relationships: orders carries customers and regions with it. So ALL(orders) also clears filters on customers and regions, slicers included. To clear just one column's filter, name the column.
Category Mix = DIVIDE([Units], CALCULATE([Units], ALL(products[category])))
The West region manager wants West's channel mix: what share of West's revenue comes from each channel. The page has a region slicer set to West. The AI assistant's shares add up to far less than 100%.
AI assistant: “Channel Share for West is ready. The shares add up to about 30% because West is about 30% of the company, so the numbers are consistent.”
Fix Channel Share so each channel's [Revenue] is divided by the revenue of all channels in the region picked in the slicer. The total row should show 1 (100%) for any region.
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