Negative Goal Growth

[Coffee1234]

Hi, 

I have a report that I am working on where I am struggling with the logic a bit.  

Store #	$ Variance (Actual-LY).	Growth Goal.	% To Goal - Expected Column
1	($500)	($500)	100%
2	($1000)	($2000)	200%
3	$200	($400)	???
4	$100	($1000)	???
5	($300)	($100)	???

I have stores that all have negative growth goals.  Some stores have had a positive variance and some stores have had a negative variance.  I am trying to write a DAX which will accurately show the % to goal.  Admittedly, I am struggling a bit with the logic for the % to goal which is making writing a DAX difficult.  I am wondering if anyone else has run into this issue or is able to help toubleshoot this for me. 

Any suggestions would be greatly appreciated!!

[Anonymous]

Hi, @Coffee1234 

May I ask if you have solved your problem? According to your description you are confused with the logic of calculating the % To Goal column when you have a negative value in the Variance column, in fact the divisor of the growth rate has to be a number greater than or equal to 0, otherwise this % To Goal is meaningless. You might consider displaying it as a numeric value only instead of a percentage.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[FreemanZ]

hi @Coffee1234 ,

this is indeed an issue. there are some recommendations like:
https://www.excelcampus.com/functions/percentage-change-formula-negative-numbers/

https://www.wsj.com/public/resources/documents/doe-help.htm#netincome

here i quote:

A positive percent change is represented in green, while a negative percent change is displayed in red. Percent change is not provided if either the latest period or the year-ago period contains a net loss.