Need Ranking as per city change

[Sajid02]

Hi Folks,

Need help on ranking as we need to show ranking as per city change and rank 1 should be the top price product.

Note:- Need to show that ranking should get changed as the city changes.

Snip for better understanding:-

Help is much appreaciated !

[FreemanZ · Accepted solution]

hi @Sajid02 

try to add a column like:

Ranking2 = 
RANKX(
    FILTER(TableName, TableName[City] = EARLIER(TableName[City])),
    [Price]
)

verified and worked like: