Sales Order fulfillment rate

DAX DAX Calculations
1

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)

2

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)

image_2021-02-26_091534
image_2021-02-26_091534948×186 22 KB

SO-josebressan.pbix (26.7 KB)

2 Likes