Forum Discussion
DAX Query
I am trying to write a dax query to calculate percentile for a value in a sub-group. Below is my query. When I run it the field for Employee Percentile Rate returns blanks. Employee Perc...
Do you need something like this?
Employee IDColumn1ScoreEmployee Percentile Rate
| E119848 | Capital Projects | 18,03 | 1 |
| E119848 | Customer Account Services | 3,63 | 0,666666666666667 |
| E119848 | Directors Office | 3,44 | 0,333333333333333 |
| E153665 | Capital Projects | 12,37 | 1 |
| E153665 | Directors Office | 4,13 | 0,666666666666667 |
| E153665 | Houston Permitting Center | 4,08 | 0,333333333333333 |
| E162855 | Capital Projects | 10,13 | 1 |
| E162855 | Customer Account Serivces | 7,75 | 0,5 |
| E098039 | Capital Projects | 16,99 | 1 |
| E155642 | Capttal Projects | 15,25 | 1 |