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...
Hi Anonymous ,
I can help you, but please let me know which are your expected numbers in Column [Percentile Rate]
Employee IDColumn1ScoreEmployee Percentile Rate
| E119848 | Capital Projects | 18,03 | 0,666666666666667 |
| E119848 | Customer Account Services | 3,63 | 0,333333333333333 |
| E119848 | Directors Office | 3,44 | 0 |
| E153665 | Capital Projects | 12,37 | 0,666666666666667 |
| E153665 | Directors Office | 4,13 | 0,333333333333333 |
| E153665 | Houston Permitting Center | 4,08 | 0 |
| E162855 | Capital Projects | 10,13 | 0,5 |
| E162855 | Customer Account Serivces | 7,75 | 0 |
| E098039 | Capital Projects | 16,99 | 0 |
| E155642 | Capttal Projects | 15,25 | 0 |