Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Clearing the date filter. To compare a month with its year, clear the month filter in the denominator. ALL on the date table clears every filter on it; REMOVEFILTERS on the month column clears only the month and keeps a year filter.
Month Order Share = DIVIDE([Orders], CALCULATE([Orders], REMOVEFILTERS('Date'[Month])))Finance tracks the year month by month against the annual revenue target: how much of the whole year's target did each month bring in?
Write the measure Share of Annual Target on targets: each month's [Revenue] divided by the [Target] for the whole year. The matrix shows it by month of 2025 next to [Revenue] and [Target]; the total row is the year's revenue over the year's target.
Matrix
Updates as you typeFilters on this visual'Date'[Year] is 2025
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe