Forum Discussion
How to calculate the Normalized Standard Deviation in Power Bi?
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
4 Replies
- Greg_Deckler
Community Champion
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?
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.
