Analyze survey using relative proportions of gender

[mmossel]

Hi,

I am analyzing a survey to which was responded by more men than women. How can I make sure to account for this difference by analyzing the percentage of men vs percentage of women their answers to certain questions instead of the absolute number.

[amitchandak]

@mmossel , Assume you have [count of answer]

the your % measure can be

Divide([count of answer] , calculate([count of answer] , allexcept(Table, Table[Question])))

or

Divide([count of answer] , calculate([count of answer] , all(Table)))

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[mmossel]

Hi @amitchandak , link to a sample dashboard is here: https://blobstorage123123.blob.core.windows.net/random/Samplereport.pbix

Thank you

[v-easonf-msft · Accepted solution]

Hi, @mmossel 

Create a mease as below to replace your original field.

%Do you see yourself being represented at all different management layers? = 
VAR count_gender =
    CALCULATE (
        COUNT ( Sheet1[What is your gender?] ),
        ALLEXCEPT ( Sheet1, Sheet1[What is your gender?] )
    )
RETURN
    COUNT ( Sheet1[Do you see yourself being represented at all different management layers?] ) / count_gender

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mmossel]

Hi, thanks for your response. The measure as such?

Gender = DIVIDE(COUNT('Survey data'[What is your gender?], CALCULATE(COUNT('Survey data'[What is your gender?], ALL('Survey data')))))

[mmossel]

hi @amitchandak , I haven't been able to solve it yet. Would be absolutely fantastic if you could have a look (without me sharing the .pbix file, preferably)