Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Row by row. Inside SUMX you can use any column of the table it walks: the row context gives one value of each column for the current row. Write the calculation for one line; SUMX repeats it for every line and adds up.
Full Price Units = SUMX(FILTER(order_items, order_items[discount_pct] = 0), order_items[quantity])
The sales director suspects some regions discount too freely. He wants the money given away in discounts, by region.
Write the measure Discount Given on order_items: for each order line, quantity times unit_price times discount_pct, added up. 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