Forum Discussion

Alaqillina's avatar
Alaqillina
New Member
1 year ago
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  
Need Help
  • BeaBF's avatar
    BeaBF
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Alaqillina ,
Glad that the issue has been resolved, please mark the helpful reply as a "Accept as solution" .It will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for your cooperation. Have a great day.