Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
DIVIDE and measures on measures. A measure can use other measures: write their names in square brackets. DIVIDE(numerator, denominator) divides, but returns blank (or an alternate value you give it) when the denominator is 0 or blank, where / would give an error or infinity.
Price Ratio = DIVIDE(SUM(products[list_price]), SUM(products[unit_cost]))
Packing costs depend on how full each box is. The operations lead wants the average number of units in a completed order, per channel.
Write the measure Units per Order on orders: completed units divided by completed orders. Build it from the library measures [Units] and [Orders], and divide with DIVIDE.
Matrix
Updates as you typeLoading the Brightline model…
Language
Full plan
Power BI ✓ · Excel and SQL also included
Cancel anytime · 14-day full refund · Secure payment by Stripe