Forum Discussion

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

Not applicable

5 years ago

Anyone?

I'm still trying using RANKX using the index column, but every row gets the value 1 for some reason..

mahoneypat
Microsoft Employee
5 years ago
Can you describe more about the analysis you plan to do once you have the desired column? I expect there is a different approach with DAX that you get your result with a live connection.

Regards,

Pat
- Anonymous
  Not applicable
  5 years ago
  As I've mentioned in my first message - my intention is to only show the rows with the value 1 (after ranking). I don't need to display the duplicates, any instance of a certain ID is enough for my analysis.
  
  So if this is my data:
  ID | Desc
  123 text1
  123 text2
  456 text1
  
  I don't care which row of ID 123 gets rank #1.
  I want to rank my entire table so every ID is displayed one time only. Super easy for me in SQL but seems impossible in DAX.
  - mahoneypat
    Microsoft Employee
    5 years ago
    It probably isn't necessary to add the rank column. For example, in a table visual you can just add the ID and Text columns and it will show only the unique combination of those columns (no duplicates). Similarly, if you make a virtual table with SUMMARIZE(Table, Table[ID], Table[text]), you can do analysis on/from that (no duplicates). Please decribe further what analysis you plan to do.
    
    Regards,
    
    Pat