Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
MAXX. MAXX(table, expression) works out the expression on each row and returns the largest result; MINX returns the smallest. MAX only looks at one stored column.
Deepest Unit Discount = MAXX(order_items, order_items[unit_price] * order_items[discount_pct])
Credit control sets a review limit for single order lines. They want to see the most valuable completed line each region has ever had.
Write the measure Biggest Line Value on order_items: the value of the single most valuable order line, after discount (quantity times unit_price times one minus discount_pct). The matrix shows it by region, for completed orders only.
Matrix
Updates as you typeFilters on this visualorders[status] is completed
Loading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe