Forum Discussion

GMadd's avatar
GMadd
Icon for Helper I rankHelper I
2 years ago

OTIF For Multiple Line Orders

I have been trying all day how to calculate OTIF for customer orders when there is multiple lines on the order. If one of the lines is short on a three line order the entire is considered short and n...
GMadd's avatar
GMadd
Icon for Helper I rankHelper I
2 years ago

Few questions

I could not get your measure for counting deliveries to work:

Total_Orders = CALCULATE(COUNTROWS('OTIF Table'), FILTER('OTIF Table', [Delivery] = MAX([Delivery])))

I used 

Total_Orders = CALCULATE(DISTINCTCOUNT(OTIF[Delivery])) and it gave me the desired result.
 
Second question 
Not sure I understand what the value should be. In my full report it produced a value of "1"

 is this the desired result?

on time in full = var _count1=COUNTROWS(FILTER(ALLSELECTED('OTIF Table'),[Delivery]=MAX('OTIF Table'[Delivery])))
var _count2=COUNTROWS(FILTER(ALLSELECTED('OTIF Table'),[On-Time]="Yes"&&[Full]="Yes"&&[Delivery]=MAX('OTIF Table'[Delivery])))
return IF(_count1=_count2,1,0)

 Thank you for responing so quickly.