I create it this measureDIVIDE ([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