Question

An analyst needs a measure that calculates the total profit margin across all order lines in a fact table. Each row has a Quantity, UnitPrice, and UnitCost column, but there is no pre-calculated line-level profit column in the model. The measure must compute profit per row (Quantity * (UnitPrice - UnitCost)) and then sum those row-level results correctly under any filter context. Which DAX approach produces the correct result?

Accepted Answer

SUMX(FactOrderLines, FactOrderLines[Quantity] * (FactOrderLines[UnitPrice] - FactOrderLines[UnitCost]))

Answer

SUM(FactOrderLines[Quantity]) * (SUM(FactOrderLines[UnitPrice]) - SUM(FactOrderLines[UnitCost]))

Answer

CALCULATE(SUM(FactOrderLines[Quantity]) * (FactOrderLines[UnitPrice] - FactOrderLines[UnitCost]))

Answer

AVERAGEX(FactOrderLines, FactOrderLines[UnitPrice] - FactOrderLines[UnitCost])