Forum Discussion

HamidBee's avatar
HamidBee
Power Participant
4 years ago
Solved

Missing Percentage values

I created a chart which shows the percentage difference over months. If the base value is zero then it doesn't show any value. I'm really nor sure what I'm misisng here. Please see below:   I...
Need Help
Show and Tell
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, HamidBee 

     

    I made a mistake in the code, I have modified '__BASELINE_VALUE' to '__VALUE_TO_COMPARE'. You can check it.

    I respect your decision, if you change your mind and have other problems, you can feel free to ask me. And 

    If my post helps, please consider Accept it as the solution to help the other members find it more quickly. Thank you.
     
    Best Regards,
    Community Support Team _ Janey
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, HamidBee 

 

As long as there is a 0 in the divisor or dividend, the result is 0. So what's your confusion?

I downloaded your sample and found no problems. Is this(create a column:[A]-[B]) what you want?

If not, What's your desired result?

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
 
Best Regards,
Community Support Team _ Janey

 

HamidBee's avatar
HamidBee
Power Participant
4 years ago

Thank you. I would like it to display the percentage increase even if the base value is zero. For example in April it went from 0  to 21 but it doesn't calculate a percentage increase. 

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    HamidBee  Can you share your desired result or your calcultion logic? I don’t understand what percentage increase you said should be presented in the visual.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    4 years ago

    Hi, HamidBee 

     

    You haven't replied to me, I don't know if your problem has been solved. 

    I asked you before, not that the problem is difficult, but I don’t know what the result you want is, according to your code, logically it should be 0...

     

    If your want is: when __BASELINE_VALUE is 0, the percentage increase shows __VALUE_TO_COMPARE, you can try Like this:

     

    PD.Mixed =
VAR __BASELINE_VALUE =
    SUM ( '2020'[Mixed] )
VAR __VALUE_TO_COMPARE =
    SUM ( '2021'[Mixed] )
VAR percentage =
    IF (
        NOT ISBLANK ( __VALUE_TO_COMPARE ),
        DIVIDE ( __VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE )
    )
RETURN
    IF ( percentage = BLANK (), __VALUE_TO_COMPARE, percentage )

     

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey
    • HamidBee's avatar
      HamidBee
      Power Participant
      4 years ago

      Apologies, I've just bene drowning with work lately. I've given it some thought and I agree with you. From a mathematical point of view their is no numerical increase if the baseline value is zero. In all of my years working with numbers this is the first time I've come across this question. I'll leave it as it is for now, unless their is a way to put "null" if the baseline value is zero.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        Hi, HamidBee 

         

        I made a mistake in the code, I have modified '__BASELINE_VALUE' to '__VALUE_TO_COMPARE'. You can check it.

        I respect your decision, if you change your mind and have other problems, you can feel free to ask me. And 

        If my post helps, please consider Accept it as the solution to help the other members find it more quickly. Thank you.
         
        Best Regards,
        Community Support Team _ Janey