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.

AtchayaP's avatar
AtchayaP
Helper V
4 years ago

I have used it.

 

 

  • 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.