Forum Discussion
Custom column Index or Ranking by other column
I would create another table with just the customers and put an index column on it. Then you should be able to relate the two tables and use the "Sort by" functionality or just filter your visual/page/report to that ID field <= 20.
In Query Editor, go to Add Column and then use the Add Index Column drop down in the General area of the ribbon (1st box).
Hi my friend,
Can I bring to P.BI, my client table even it has half milion of records?
or How can I create a RANK measure in my table? I need to rank and show only all my 20 big clients
Sure, half a million records should not be too much of a problem, I've created datasets with millions of rows in them.
According to your description, you want to create a rank column which only increases when group changes. Right?
In this scenario, you can just use RANKX() to dense rank based on the group column, please refer to my sample below:
rank = RANKX(Query1,Query1[Table_DAX_sorting[name]]],,ASC,Dense)
Regards,