How to calculate the Normalized Standard Deviation in Power Bi?

[Anonymous]

Hello, 

I have 16 employees from 2 countries. The Dataset contains multiple records for each employee.

1. I need to show Total Salary per employee/country based on filters content (i.e months, country)

Salary = SUM ( dimSalaryPerEmployee[Salary]  )

2. I need to show Average Salary per employee/country based on filters content (i.e months, country)

Avg = AVERAGE ( dimSalaryPerEmployee[Salary] )

3. I need to show Normalized Std of Salary per employee/country based on filters content (i.e months, country)

Std =  STDEV.S ( dimSalaryPerEmployee[Salary)

I need to have a Normalized Std measure per country! Meaning each employee will be evaluated in its own country.

Normalized Std = (Salary-Avg)/Std

How can I tell Dax to use an Avg for the country that is in the current context?

Thanks,

Tamir

[Greg_Deckler]

Seems like you could just wrap those measures in a CALCULATE with a FILTER for the country or maybe I don't understand what you are asking for?

[Anonymous]

I believe you understand perfectly 🙂

I tried,

Normalized Std = calculate((Salary-Avg)/Std,ALL(dimCountries[Country])

and of course it doesn't work...

I think I need to do 

Normalized Std = calculate((Salary-Avg)/Std,FILTER(dimCountries[Country]=????)

 but I don't know what to put in the ????

Thank you for the help,

Tamir

[Greg_Deckler]

Well, you could create two measures, one for each country and then you would just plug in the country name in double quotes.

[Anonymous]

It is just a sample...I have around 60 countries...