Rank the duplicates values

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