Forum Discussion
Solved
Percent Measure higher than 100%
Hi,
It's maybe really basic but I can't get around it, this is my measure:
Sales% = DIVIDE(SUM(Sales2018[Investment]);SUM(Sales2017[Investment]))
In some of cases this will get value higher than 100% (like 116%) but I would like to this play this value as +16%, is there some way to do this?
Hi KelvinMorel,
Based on my test, you could refer to below formula:
Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"
Result:
You could also download the pbix file to have a view.
Regards,
Daniel he
2 Replies
Hi KelvinMorel,
Based on my test, you could refer to below formula:
Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"
Result:
You could also download the pbix file to have a view.
Regards,
Daniel he
Hei v-danhe-msft,
Thank you so much, you help me out. I needed to modify a little bit your measure as follow: if you see another way please share
Sales% = (DIVIDE(SUM(Sales2018[Investment]);SUM(Sales2017[Investment]))-1)
> To get numbers
Sales%Sign = IF([Sales%]>0;"+"&ROUND(([Sales%]*100);0)&"%";ROUND([Sales%]*100;0)&"%")
> To get the signs in front
