Forum Discussion

o59393's avatar
o59393
Post Prodigy
1 year ago
Solved

How to hide -100% values

Hi all   The dax "Detlta Growth" works well, the issue is with the -100% that I cannot hide as seen below:         Delta Growth = DIVIDE(SUM('Append OU Demand'[OU Demand])-[LY OU Dema...
Need Help
Show and Tell
  • sevenhills's avatar
    sevenhills
    1 year ago

    Try this, as you have not uploaded .pbix, just a guess: You are trying to hide either for future dates and/or SUM([OU Demand]) has no value. Try to change somewhat like below to all measures. 

           IF Statement, BLANK(), Calculated value. i.e., if Statement and calculation formula varies for each measure. 

     

     

    Delta Growth = 
VAR _R = DIVIDE(SUM('Append OU Demand'[OU Demand])-[LY OU Demand],[LY OU Demand],BLANK())

RETURN IF ( _R = 1.00, BLANK(), _R)

     

     

    Not complete solution, but giving the steps 🙂