Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
AVERAGEX. AVERAGEX(table, expression) works out the expression on each row and averages the results. AVERAGE can only average a stored column; AVERAGEX averages something you calculate per row.
Avg Units per Discounted Line = AVERAGEX(FILTER(order_items, order_items[discount_pct] > 0), order_items[quantity])
The pricing team wants to know what a typical order line is worth in each customer segment, after discount.
Write the measure Avg Line Value on order_items with AVERAGEX: the average value of one order line, after discount (quantity times unit_price times one minus discount_pct). The matrix shows it by segment, 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