How to divide a column value by a measure?

[Jacobzlyons]

HI Fairly new to Power BI so probably a basic question. 

How would I calcualte the below please? 

Count “BME” values from Ethnic group column

Divided

by all the values in the ethnic Group column

i.e I have 3 BME, 4 white Staff, 3 Unknown, i would expect the outcome to be 30% for BME staff

[Thejeswar · Accepted solution]

Hi @Jacobzlyons ,

You can get it by using the below DAX in a Calculated measure

BME% = 
Var A = CALCULATE(COUNT('Table'[Ethnic_Group]),'Table'[Ethnic_Group] = "BME")
Var C = COUNT('Table'[Ethnic_Group])
RETURN
DIVIDE(A, C)

Set the measure as a %

Regards,

[Jacobzlyons]

Thats perfect, thank you!