Get the Average % of 1 column in Card

[blockobito]

Hello i need to get the Average Percentage of 1 column data

Example: 

Gender

Male

Female 

pGender = Count(Data[Gender]) = "Male" / Count(Data[Gender]) = "Female" 

[FreemanZ · Accepted solution]

Try to create a measure like this:

 

pGender := 

VAR CountMale = 

CALCULATE( 

    COUNTROWS(Data),

    Data[Gender]) = "Male"

)

VAR CountFemale = 

CALCULATE( 

    COUNTROWS(Data),

    Data[Gender]) = "Female"

)

RETURN

    DIVIDE (CountMale, CountFemale)