Get percent of total by count of value by Customer

[Thedatadude]

Hello All, 

I am trying to calculate via Measure on a dashboard the % of 3 values in a column for each of my customers in our gender column. F is female, M is male, and I is undisclosed. This is what I have tried thus far... the dashboard does filter on multiple customers. So in the below we may have Google1, Google 2 so the multiple selection is needed. If all google accounts are selected via slicer Male would be 75% for just Google2 it would be 50%. etc. 

GENDER2 =

COUNT(Query1[Gender]) / CALCULATE(COUNT(Query1[Gender]) , FILTER('Query1',)))

Customer	Gender
Google 1	M
Google 1	M
Google 2	F
Google 2	M
Microsoft	I
Microsoft	I

[dax · Accepted solution]

Hi @Thedatadude , 

You could try below measure

Measure = CALCULATE(COUNT('Table'[Gender]))/CALCULATE(COUNT('Table'[Gender]), ALLSELECTED('Table'))

Best Regards,
Zoe Zhi

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

[jeroenterheerdt]

so close 🙂 just thought of allselected this morning, but you beat me to it.

[jeroenterheerdt]

not sure if this is what you're looking for, but:

% by Gender = 

var result = DIVIDE (

 [GenderCount],

 CALCULATE (

 [GenderCount],

 ALL (

 'Table'[Gender]

 )

 )

 )

return result

with another measure that is:

GenderCount = COUNT('Table'[Gender])