Solved: Re: Powerbi

AtchayaP · ‎06-28-2022

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

Anonymous · ‎06-28-2022

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 · ‎06-28-2022

I have used it.

Anonymous · ‎06-28-2022

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 · ‎06-28-2022

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

Regards,

Pranit

Powerbi