Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
ALL. Inside CALCULATE, ALL(table) or ALL(Table[Column]) removes the filters on that table or column, so the expression sees every row again. Filters on other tables, such as a channel slicer or a date filter, stay in place.
All Category Units = CALCULATE([Units], ALL(products))
Regional managers keep asking how their region compares with the whole company. The sales director wants the company's revenue printed next to each region's own figure.
Write the measure Company Revenue on order_items: [Revenue] for all regions together, shown on every region row. The matrix shows it by region 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