Calculate percentage based on other column

[dofrancis3]

Dear Team;

Please i'm requesting your support regarding the DAX mesure. 

I would like to calculate the percentage (lethality rate):

1. According to to the Gender

2. According to The gender and the region

Thank you

[dofrancis3]

Dear @SGroff ,

Thank you so much for your support.

But if i have the tables (1srt one OR second one) below how can i calculate the percentage? (Dax)

[SGroff]

I think you're asking me if you can calculate mortality percentages for different populations, for example, females between the ages of 5 and 14.  Calculate() allows you to filter by more than one field.  See above where I filtered the countrows() expression by gender and mortality.  Simply seperate the different arguments by a comma. 

[SGroff · Accepted solution]

Hi,

I would declare variables and use the calculate and countrows functions. I'm not sure what your table names are but I imagine your dax should look something like this:

PercentByGender =

VAR TotalFemalesInfected = CALCULATE(
                                             COUNTROWS('TableName'[GENDER]),

                                             'TableName'[Gender]="F"
)

VAR FemalesDie =

                                            CALCULATE(
                                             COUNTROWS('TableName'[GENDER]),

                                             'TableName'[Gender]="F",
                                             'TableName'[Death]="1",
)

VAR LethalityRateFemales = DIVIDE(FemalesDie, TotalFemalesInfected,0)

RETURN

IF(LethalityRateFemales>0,LethalityRateFeamles, 0)

I put that IF() statement in the return of a lot of my measures that I use in cards because I hate it when the answer is 0% and the card shows "(BLANK)."

You can use similar expressions for the other percentages you want to find.

Remember if you click on your measure, then modeling, you can modify the result to return a percentage and how many decimal places you want to show. 

One final caveat, the calculate() function tends to wreak havoc if you want to use this measure for a drill through.