Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
RELATED. RELATED(Table[Column]) reads a column from the one side of a relationship for the current row: on an order line, RELATED(products[category]) is the category of that line's product. It needs a row context, so use it inside an iterator or a calculated column.
Paper Units = SUMX(order_items, IF(RELATED(products[category]) = "Paper & Print", order_items[quantity]))
Finance wants the cost of goods sold next to revenue for each category. What one unit costs Brightline lives on the products table; the quantities live on order_items.
Write the measure Cost of Goods on order_items: for each order line, quantity times the product's unit_cost from the products table, added up. The matrix shows it by category for completed orders, next to [Revenue].
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