Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Powerbi

i am trying show as 57.39% though I have changed in format panel.but I get  5739.any idea?

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi AtchayaP 

    Ok, you have a *100 extra in the calculation.

     

    Using the below measure 

    %val = DIVIDE(SELECTEDVALUE('Table'[skills]),CALCULATE(sum('Table'[skills]),ALLSELECTED('Table'[Name])))
    I get the below chart.

     

    Hope, it resolves your issue.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi AtchayaP 

    You are missing "/100" in your calculation. putting that will resolve the above issue.

     

    Regards,

    Pranit

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi AtchayaP 

      Ok, you have a *100 extra in the calculation.

       

      Using the below measure 

      %val = DIVIDE(SELECTEDVALUE('Table'[skills]),CALCULATE(sum('Table'[skills]),ALLSELECTED('Table'[Name])))
      I get the below chart.

       

      Hope, it resolves your issue.