Forum Discussion
Display as % messing up
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" ))) * 100And 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.
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! 😀
2 Replies
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! 😀