Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you mahoneypat for bearing with me, but I feel like I'm not explaining myself correctly.

 

I do have unique rows in my table visual. If you could please take a look at the image I added - the ID '123' has three different text values. Each row of the three is unique, but I don't care for the other two. 

This is why I wanted to use a rank function, so I'd rank by ID in ascending order and filter out values that are greater than 1.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

If I were to write it in SQL:

rank() over(partition by ID, order by Description) as rank.

 

Hope this clarifies.

 

Anyone please..?

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    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