1 ACCEPTED SOLUTION
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
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.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @AtchayaP
You are missing "/100" in your calculation. putting that will resolve the above issue.
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
