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