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
It would be easier for us to figure out what you're trying to acheive by posting a sanitized copy of your pbix (no confidential information). You can post a link to a file stored in the cloud. I know it takes an effort to do so but so is providing an answer. Please read this post: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
danextian Thank you. Here is what I'm trying to do:
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% |