Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
CALCULATE replaces filters. When a CALCULATE filter is on a column the cell already filters, it replaces the cell's filter on that column. That is how one measure can show the same benchmark on every row. KEEPFILTERS(condition) does the opposite: it keeps the cell's filter and adds yours.
Online Benchmark = CALCULATE([Orders], orders[channel] = "Online")
Paper & Print is Brightline's anchor category. The category manager wants a benchmark column that shows Paper & Print revenue on every row, so each category can be read against it.
Write the measure Paper Benchmark on order_items: [Revenue] for the Paper & Print category, shown on every category row. The matrix shows it by category 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