Forum Discussion
Solved
If Statement in Measurement
Hi All Thank you for your help in advance. i am trying to do a truck utilization for each lane we have the fake details as below: Truck_Lane Chargeable 1:6 FRAMLH 6814 FRACDG 893 ...
Ericwhv , Try like
Truck Utilization(AVG) = DIVIDE([Avg Chrg Weight Per Truck], if(Max(Table[Truck_Lane]) in {"FRAMLH","MLHCDG"} , 5333, 10666))
Ericwhv , Try like
Truck Utilization(AVG) = DIVIDE([Avg Chrg Weight Per Truck], if(Max(Table[Truck_Lane]) in {"FRAMLH","MLHCDG"} , 5333, 10666))