cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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?

1 ACCEPTED SOLUTION
Microsoft Employee

Hi @KelvinMorel,

Based on my test, you could refer to below formula:

`Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"`

Result:

Regards,

Daniel he

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft Employee

Hi @KelvinMorel,

Based on my test, you could refer to below formula:

`Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"`

Result:

Regards,

Daniel he

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper II

Hei

`Sales% = (DIVIDE(SUM(Sales2018[Investment]);SUM(Sales2017[Investment]))-1)`

`Sales%Sign = IF([Sales%]>0;"+"&ROUND(([Sales%]*100);0)&"%";ROUND([Sales%]*100;0)&"%")`

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.