Rankx in measure

[Supakit_1]

I would like to making index key for my product in table visualization. My table look like this

UniqProductID	ProductName
156	A
156	A
964	B
789	C
789	C

I using this dax in my measure

index = RANKX(

tblProduct ,MAX(tblProduct [UniqProductID]),,ASC,Dense

)

index is alway show as "1" .

I would like to show result like this.

 Filter : A,B,C

Index	UniqProductID	ProductName
1	156	A
1	156	A
2	964	B
3	789	C
3	789	C

Filter : A,C

Index	UniqProductID	ProductName
1	156	A
1	156	A
2	789	C
2	789	C

So, Index field will be dynamic per filter selection. How to write dax as per expected result.

Thank you.

[wdx223_Daniel]

index = RANKX(

tblProduct ,calculate(MAX(tblProduct [UniqProductID]),ALLEXCEPT(tblProduct,tblProduct [UniqProductID])),,ASC,Dense

)

[VahidDM]

EDITED

Hi @Supakit_1 

Try this measure:

index = 
RANKX (
    ALLSELECTED ( tblProduct ),
    CALCULATE (
        MAX ( tblProduct[ProductName] ),
        ALLEXCEPT ( tblProduct, tblProduct[ProductName] )
    ),
    ,
    ASC,
    DENSE
)

Output:

You can also download the file: https://gofile.io/d/4JJQpK

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

Appreciate your Kudos✌️!!