Forum Discussion
Solved
Rank the duplicates values
Hi community, have the next issue. I have several values I have to rank. The problem is that ranks function assign the same rank to each row and there is no any identifier to break the tie....
Hi Paulshap
You could create a new calculated table:
New table = GENERATE ( DISTINCT ( Table1 ), GENERATESERIES ( 1, CALCULATE ( COUNT ( Table1[sale_contract_id] ) ) ) )Otherwise perhaps you can create the equivalent of the calculated table in PQ and add an index afterwards.
I don't think it is possible to add a column like that directly in DAX (witout creating a new table) since there is nothing to differentiate the duplicates. In any case, what is the point of this? What are you trying to do, ultimately? Most likely it can be done without that column, since it doesn't seem to add any information.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
