Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
6 years ago

Measure Support

Hi Team, this is my current measure Var_H = IF(SUM('SLSL Planning template'[plannedHours])=0&&SUM(SLSL[Actual Charge(Rev/Mer)])=0, "",SUM(SLSL[Actual Charge(Rev/Mer)])-SUM('SLSL Planning template'...
Need Help
Show and Tell
Tahreem24's avatar
Tahreem24
Super User
6 years ago

vjnvinod ,

 

Give a try to below measure. I have revamped your measure.

 

Var_H = IF(SUM('SLSL Planning template'[plannedHours])<>0&&SUM(SLSL[Actual Charge(Rev/Mer)])<>0,SUM(SLSL[Actual Charge(Rev/Mer)])-SUM('SLSL Planning template'[plannedHours]))

 

PLease hit Thumbs up for support and accept this as a solution if it helps you!