Solve Gender Bias in Survey using relative percentage per category in one column

[mmossel]

Hi,

I am analyzing a (gender equality) survey with 132 male and 93 female respondents. This gender imbalance in the sample influences the interpretation of survey questions, where men have a majority of the vote. How can I instead create a relative percentage of the votes per gender? So if 93/93 women vote YES, and 132/132 men vote NO, the visual should show a 100% men and 100% women. If 46.5/93 women vote YES and 66/132 men vote NO, then both visuals should show 50%.

So I would like to use the relative percentage of votes within that category of gender.

That means on the visual left, which describes just the respondents, it should show 100% on both bars.

Sample dashboard: https://blobstorage123123.blob.core.windows.net/random/Samplereport.pbix

Thank you so much!

[mmossel]

hi @amitchandak,

Have you been able to download the sample report that I shared? Let me know, I've still not been able to solve the problem without you. Thank you!

[amitchandak]

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

On of the new measure for the first bar can be(assuming you are using measure)

divide([measure], calculate([measure], allexcept(Table, Table[gender])))

[mmossel]

Hi @amitchandak 

Thank you, it's in the description now. I'll link it here too: https://blobstorage123123.blob.core.windows.net/random/Samplereport.pbix

[amitchandak · Accepted solution]

@mmossel , Please find if the attached file after signature can help