Measure Support

vjnvinod · ‎12-05-2019

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 · ‎12-08-2019

Hi @vjnvinod ,

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

You could check if it works.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Tahreem24 · ‎12-05-2019

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

vjnvinod · ‎12-05-2019

@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