Forum Discussion
How do I RANKX over text duplicates?
Hi, I've tried some of the examples of text rankings in this forums, with little to no success. Here's what I'd like to achieve: My goal - filtering out all values that are different t...
If I were to write it in SQL:
rank() over(partition by ID, order by Description) as rank.
Hope this clarifies.
Anyone please..?
One more suggestion. Since you don't care with the three 123 text values is displayed, I would just make a table visual with the ID column and this measure
Text Values = MIN(Table[Description])
That will result in one row per ID and just one of the Description values.
Regards,
Pat