Forum Discussion

Sajid02's avatar
Sajid02
Helper I
3 years ago
Solved

Need Ranking as per city change

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...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Sajid02 

    try to add a column like:

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

     

    verified and worked like:

     

     

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Sajid02 

try to add a column like:

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

 

verified and worked like: