Measure Support

[vjnvinod]

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'[plannedHours]))

what i want to do is

IF(SUM('SLSL Planning template'[plannedHours])=0&&SUM(SLSL[Actual Charge(Rev/Mer)])=0

instead of showing the condition as blank, i want to hide those results

how do i achieve this?

[v-eachen-msft]

Hi @vjnvinod ,

I think the easiest way is to set rules in the filter.

You could check if it works.

[Tahreem24]

@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!

[vjnvinod]

@Tahreem24 

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

[vjnvinod]

@Tahreem24 

@parry2k 

@Zubair_Muhammad 

Can you someone please help me with this?