Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper 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.

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