Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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_We...
Need Help
  • lkalawski's avatar
    lkalawski
    6 years ago

    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! 😀

lkalawski's avatar
lkalawski
Resident Rockstar
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago
Easier than expected 😄 Thank you.