% male and female in card DAX

[RK_JOB]

Hi,

I am trying to find the % of male and Female from the total headcount. This is a formula for Male. I created same formula for female.

and I get correct value.

The problem happens if I click on "female" somewhere on the page then due to formula, it still keeps 8,489 for male in internal memory as I think Filter in the formula takes precedence and divides 8,489/12,680 and gives me 67% which is clearly wrong. How do I create DAX properly in this situation?

The number card comes correct because I put a filter in filter pan as "male" for gender.

Thanks in advance,

RK

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Male headcount = calculate([headcount],filter(values(HC[Gender_text]),HC[Gender_text]="Male"))

% male = divide([Male headcount],[headcount])

Hope this helps.