Forum Discussion
Ranking without ties
Hi, I am learning DAX and am struggling with an issue ranking a table to get a Top N result. I have many ties as the data set is not large. The table is already filtered using the filtering in ...
OwenAuger
Super User
Super UserHi KMont
Either the RANK or ROWNUMBER functions should be useful here, as they allow ranking based on multiple measures/columns.
Could you clarify which columns/measures you want to appear in your final visual (aside from ranking measures), and also show a snapshot of the underlying 'RX Counts' table (santised if needed)?
e.g. Do you want to see
| Abbreviation | drug_generic_name | Rx Total |
Regards