Sales Order fulfillment rate

jbressan · February 26, 2021, 2:16pm

Use this two Measures

Completed Order = 
SUMX(
	SUMMARIZE('Table',
	'Table'[Sales Order#],
	"_Complete", IF(sum('TABLE'[Qty Ordered]) = sum('TABLE'[Qty Shipped]),1,0)
	), [_Complete])

and

Sales Order fulfillment rate = 
VAR _Orders = CALCULATE(DISTINCTCOUNT('Table'[Sales Order#]), ALLSELECTED('Table'))

VAR _CompletedOrder = CALCULATE([Completed Order], ALLSELECTED('Table'))

Return DIVIDE(_CompletedOrder,_Orders)

SO-josebressan.pbix (26.7 KB)