Forum Discussion
Need help with DAX Measures and Ranking
v-sgandrathi Hello. I tried to do this, but gave up as I had multiple visuals that are synced. So I am skipping the top 3 and bottom 3, and just showing the sort by highest SLA. If I get to the point where management is asking for only the top 3, then I'll revisit this. And as for the bottom 3, if there was nothing that met the .8 or lower filter, there was nothing to show, which led to confusion. Thank you for your help. I really appreciate it.
Hi niemis,
I wanted to check if you had the opportunity to follow up on our previous conversation. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution.
Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.
Thank you.
v-sgandrathi thank you. This is what I'm trying to accomplish:
In this table, for the month of April, I am trying to show the highest number of tickets with highest SLA Achievement. And in contrast, the highest number of tickets with the lowest SLA Achievement. The Assignment group isn't static; if I chose another department they could have more or less Assignment Groups.
| Month | Department | Assignment Group | Total | SLA Achievement |
| 25-Apr | Development | BaT SW | 123 | 73.17% |
| 25-Apr | Development | BSE Compute | 101 | 76.24% |
| 25-Apr | Development | BSE Storage | 80 | 68.75% |
| 25-Apr | Development | Componentization | 24 | 58.33% |
| 25-Apr | Development | DevApps Nagios | 96 | 94.79% |
| 25-Apr | Development | Testing IA | 25 | 72.00% |