Hi , @Anonymous
Create mesure as below:
Test =
var currentOrder = MAX('Sheet1'[order_to_delv])
var nextOrder = CALCULATE(MIN('Sheet1'[order_to_delv]),FILTER(ALLSELECTED(Sheet1),'Sheet1'[order_to_delv]>currentOrder))
var NextRunningTotal =
SUMX (
CALCULATETABLE(DISTINCT('Sheet1'[order_to_delv]),
FILTER (
ALLSELECTED ( Sheet1),
Sheet1[order_to_delv] <=nextOrder
)),
CALCULATE(
DIVIDE (
CALCULATE(COUNT ( Sheet1[order_no] )),
CALCULATE (
COUNT ( Sheet1[order_no] ),
ALLEXCEPT ( Sheet1, Sheet1[hp_receive_date], Sheet1[order_no] )
)
)*100)
)
var CurrentRunningTotal = [RunningTotal]
return IF(CurrentRunningTotal<90 && NextRunningTotal>=90,(currentOrder + (90-CurrentRunningTotal)/(NextRunningTotal-CurrentRunningTotal)),0)
Check below pbxi file.
pbix attached
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
