Calculate Percent f filtered data

[Ryansong]

Hello everyone

I have a data of employee number by sex like  the following.

sex                      number

female                       5

male                        10

male                         8

I need to calculate for example: Percent of male employee number showing separately in Card visual.

In case of this how should i write DAX expression for this.

Please help me 

Thank you🤗🤔

[nandukrishnavs]

@Ryansong 

Create DAX measure

Male = CALCULATE(SUM(MyTable[number])/SUMX(ALL(MyTable),MyTable[number]),MyTable[sex]="male")

Female = CALCULATE(SUM(MyTable[number])/SUMX(ALL(MyTable),MyTable[number]),MyTable[sex]="female")

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Greg_Deckler]

@Ryansong - Should be,

Percent = SUMX(FILTER(ALL('Table'),[sex]="male"),[number]) / SUMX(ALL('Table'),[number])