Here is the scenario . I have a category column and a measure which is simply the count of rows for the table. Now i need to rank the categories of that table based on the count measure. Thing is there are a lot of categories for which the count is tied or same.
First i need to break the ties so that rank can be given in ordinal/continuous fashion like 1,2,3,4,5 without any repetition of rank.
Solution which I have tried are also in the pbix. For heads up i have tried break the ties using median and also tried to break the ties with rand and randbetween.Rank With Ties issue.pbix (66.4 KB)
Attaching the sample PBIX for everyone.