Percentage Measure

[PlentyL]

Hi,

I am trying to create a percentage of BAME employee's within my 'HC' table. I have ethnicity group within the HC table also, but need to select "Asian", "Black", "Mixed". 

How do i filter the count for the Ethnicty group without filtering the Count of employee ID too?

Thanks in advance.

[PlentyL · Accepted solution]

I may have gone about this a long way but its now working.

I have a count of BAME with a filter for the ethnicity groups i need. 

Then i have created another measure dividing the HC by my BAME count.

This has now given me the right percentage.

[v-yalanwu-msft]

Hi, @PlentyL ;

Try it.

Bame% =
DIVIDE (
    DISTINCTCOUNT ( 'HC'[EMPLOYEE ID] ),
    CALCULATE ( COUNT ( 'HC'[Ethnicity Group] ), ALLSELECTED ( 'HC' ) )
)

Or can you share a simple example and the result you want to output?which could understand your logic more clearly.

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

[PlentyL]

Unfortunately that wont work, as i am not looking for the amount of ethcnity groups, but the amount of employee ID's against certain ethnicty groups. Apologies if i wasnt clear.

I basically need to get a percentage of 100 (amount in a bame group) /2000 (Number of distinct employee ID's).

[amitchandak]

@PlentyL , Like

distinctcount('HC'[ethnicity group])