Forum Discussion
KelvinMorel
Helper II
Helper IIPercent 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 tha...
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
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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
- KelvinMorel
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
