Rank Duplicates values in a sequence

[Anonymous]

I Need to find the Below result by creating a measure
For every Duplicates rows it is showing sequence 

I have created calculated column but not able to create a measure

Calculated Column:

Ranking = rankx(filter(table, userId = earlier(table[userId]) && date = earlier(date)), table[userId] + table[index],,asc,dense)

Requires a measure

Any help will be appreciated

Thank you all

[Ashish_Mathur · Accepted solution]

Hi,

Share the download link of your PBI file.

[Anonymous]

Hello sir,
Here I have attached the link of pbi file I have solved that problem but anything I can improved in that please tell me
https://drive.google.com/file/d/1XpuyM1ArXWtGMAFXcTmA9aLU74Y34chh/view?usp=sharing

[Ashish_Mathur]

If the solution works well, please stick to it.

[lbendlin]

There be dragons

Use of RANKX in Power BI measures - SQLBI