Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mmossel
Microsoft Employee
Microsoft Employee

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

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.

mmossel_0-1611331149586.png

 

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

Thank you so much!

 

1 ACCEPTED SOLUTION

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

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

4 REPLIES 4
mmossel
Microsoft Employee
Microsoft Employee

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
Super User
Super User

@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])))

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

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

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.