Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
REMOVEFILTERS. REMOVEFILTERS(table) or REMOVEFILTERS(Table[Column]) works like ALL inside CALCULATE: it clears filters, and its name says so. It only works as a CALCULATE filter argument. Clear as little as you need: every filter you don't name, slicers included, stays in place.
Share of All Segments = DIVIDE([Units], CALCULATE([Units], REMOVEFILTERS(customers[segment])))
The e-commerce lead wants to know which regions drive online sales. The report page has a channel slicer, set to Online.
Write the measure Region Share on order_items: each region's [Revenue] divided by the revenue of all regions, using REMOVEFILTERS. The share must follow the channel slicer, so the total row shows 1 (100%) whichever channel is picked.
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