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 Demand],[LY OU Demand],BLANK())

 

 

Problem might be because of the "LY OU demand" measure that returns (correctly) the previous date demand as seen for 2026:

 

How can I hide the -100% values from the table to have something like this below (without showing 2026)?

 

 

Thanks.

 

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 🙂

2 Replies

  • sevenhills's avatar
    sevenhills
    Super User
    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 🙂