Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
LOOKUPVALUE. LOOKUPVALUE(Table[Result], Table[Search], value) returns Result from the row where Search equals value, with no relationship needed. Inside SUMX, the value can be a column of the current row. Prefer RELATED when a relationship exists; LOOKUPVALUE is for when it doesn't.
Manager = LOOKUPVALUE(regions[manager], regions[region_id], customers[region_id])
In this copy of the model, products isn't connected to order_items yet, and the model owner is away. Sales ops wants to know what the completed lines would have brought in at list price, to see how far below list Brightline sells.
Write the measure List Price Sales on order_items: for each order line, quantity times the product's list_price, added up. products has no relationship to order_items here, so look the price up by product ID with LOOKUPVALUE. The matrix shows it by channel 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