Forum Discussion
Solved
How to create new percentage measure?
I create it this measure DIVIDE ([Headcount], CALCULATE([Headcount], ALLSELECTED( 'Basic Information'))) so based on this function I want to show the female percentage in the card
Alaqillina Hi! you can use:
Female Percentage =
DIVIDE(
CALCULATE([Headcount], 'Basic Information'[Gender Desc] = "Female"),
CALCULATE([Headcount], ALLSELECTED('Basic Information'))
)If it's ok, please accept the answer as solution.
BBF
Thank you the it's a good solution
Hi Alaqillina ,
I'm glad to hear that your query was resolved! If our response addressed your query,please consider
marking it as Accept as Solution and give us Kudos if you found it helpful.
Thank you for your cooperation. Have a great day.