Forum Discussion

Sajid02's avatar
Sajid02
Icon for Helper I rankHelper 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.

Snip for better understanding:-

 

Help is much appreaciated !

 

 

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:

     

     

1 Reply

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper 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: