Display as % messing up

[Anonymous]

Hi I have made a measure:

Share % = CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store1" )) / (CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store2" )) + CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store1" ))) * 100

And this gives me the correct answer in numbers for every year. For 2018 it gives 19.80, 2019 and 2020 it gives 19.18. Now I need it to show as % and when I click "Display the values in this column in percentages" it messes everything up. I need it to show as 19.80% but instead it gives me 1979.71%. Share value can't be more than 100%....

Tried formating:

Shares % = FORMAT([Share %],"0.00%")

but this gives me the same result.

[lkalawski · Accepted solution]

@Anonymous

Try without this "* 100" at the end. And you will see the proper percentage values.

Share % = CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store1" )) / (CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store2" )) + CALCULATE(SUM('DATA_Weekly'[Sum_of_VALUE]),FILTER('DATA_Weekly', 'DATA_Weekly'[chain] = "Store1" )))

You are shown percentages because you want to convert a number to a percentage. Always with such an operation you should divide the value by 100. In your case it is enough to remove the last multiplication.

_______________
If I helped, please accept the solution and give kudos! 😀

[Anonymous]

Easier than expected 😄 Thank you.