Help with DAX to rank the duplicates

[Anonymous]

CATEGORY	QUANTITY	RANK
A	10	1
A	10	2
B	20	1
C	30	1
C	40	2

I have a table similar to this and I have listed the desired rank column. I need a calculated column to rank based on the dates eventhough it has duplicates.

Need sequence for each duplicate values.

Looking forward to your help.

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

rand = RAND()

rank =
RANKX(FILTER(ALL('Table'),'Table'[Category]=EARLIER('Table'[Category])),'Table'[Quantity]+'Table'[rand],,ASC,Dense)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

How to create measure for this?

[VahidDM]

@Anonymous 

Can you add a sample table with all important columns?(Date column?)

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[Anonymous]

@VahidDM please refer below table, need to sort as per the category field.

CATEGORY	RANK
A	1
A	2
B	1
C	1
C	2