topic Re: Calculate Percent f filtered data in DAX Commands and Tips

Calculate Percent f filtered data

Ryansong — Mon, 25 May 2020 05:06:51 GMT

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🤗🤔

Greg_Deckler — Mon, 25 May 2020 05:13:07 GMT

Ryansong - Should be,

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

nandukrishnavs — Mon, 25 May 2020 05:14:45 GMT

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 🙂