Forum Discussion
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'...
this is incorrect measure
my measure is correct, the only thing i want to do is to hide those rose instead of returning blank
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]))
see the highligted ones below in the pic, these are the rows, i don't want to see in my visual