Percent Measure higher than 100%

[KelvinMorel]

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?

[v-danhe-msft · Accepted solution]

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

[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