Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUMX. SUMX(table, expression) works out the expression on each row of the table, then adds up the results. Use it when the number you need isn't stored in a column but is calculated from several columns of the same row.
Discounted Units = SUMX(order_items, order_items[quantity] * order_items[discount_pct])
Finance wants gross sales: what the completed order lines were worth at the price charged, before any discount was taken off.
Write the measure Gross Sales on order_items: for each order line, quantity times unit_price, added up. The matrix shows it by category, 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