Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Ratios of measures. Two measures from different tables can meet in one formula. Each is filtered by the same row first, here a quarter, and then the formula combines the two results. A ratio of 1.1 means 10% above plan.
Revenue per Customer = DIVIDE([Revenue], DISTINCTCOUNT(orders[customer_id]))
The board pack needs one line per quarter of 2025: how much of the revenue target Brightline actually reached.
Write the measure Target Attainment on targets: Revenue as a share of Target (1 means exactly on target). Use the library measures and divide with DIVIDE. The matrix shows it by quarter of 2025.
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