Gender wise Percentage showing incorrrect

[ayush75031]

Hi Folk,

Hope you are doing well

I want to show the number of Exit Customers and their percentage by gender. Below is a screenshot  

If I select the Gender Category slicer, I get 100% as you can see below.

  It should give me an accurate percentage i.e. female 55.92% and male 44.08%, and their respective numbers. Edit Interaction should be avoided. Dax or something else other than Edit Interaction should be used to accomplish this  

Thank You

[v-tianyich-msft · Accepted solution]

Hi @ayush75031 ,

I think there's a misunderstanding that once you've selected a gender via slicer, that means the total only includes the selected gender, so it must be 100%.If you need to highlight a section, just click on the corresponding block of the pie chart.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[manvishah17 · Accepted solution]

Hi @ayush75031 , 
The above stated solutions are correct, the otherway us, if you want that you select the slicer and pie chart don"t get changes then you can use EDIT INTERACTIONS opt.

Select slicer, go to format ->Edit interactions -> none on pie chart 

 after that this will be the output 

[v-tianyich-msft · Accepted solution]

Hi @ayush75031 ,

I think there's a misunderstanding that once you've selected a gender via slicer, that means the total only includes the selected gender, so it must be 100%.If you need to highlight a section, just click on the corresponding block of the pie chart.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[ayush75031]

Hello @danextian ,

Thank you for your quick response. I want to show numbers along with Percentages in Pie Chart

[danextian]

Hi @ayush75031 ,

You need  to alter the filter context on your denominator. Try:

DIVIDE ( [measure], CALCULATE ( [measure], ALL ( 'table'[gendercategory] ) ) )