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'[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?
 
 
Need Help
Show and Tell

4 Replies

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

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      6 years ago

      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