Sales Order fulfillment rate

We have 4 sales orders with two lines each. Two of the sales orders we shipped complete, two of the sales orders we only shipped one line and did not ship the second line. How do I calculate that we had a fulfillment rate of 50%?
SO.pbix (25.1 KB)

Hi @Usates

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)

2 Likes