Forum Discussion

Stephy_99's avatar
Stephy_99
New Member
3 years ago
Solved

Reset RANKX when two values change

Hi everyone! I need some help with this issue, I have a table with Location and ID and I want to reset the rankx when both values change. I tried to use this formula but it's not working: R...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Stephy_99 ,

    Please try below steps:

    Add a new column with below dax formula

    Rank =
VAR cur_location = 'Table'[Location]
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Location] = cur_location )
RETURN
    RANKX ( tmp, [ID],, ASC, DENSE )

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Stephy_99 ,

Please try below steps:

Add a new column with below dax formula

Rank =
VAR cur_location = 'Table'[Location]
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Location] = cur_location )
RETURN
    RANKX ( tmp, [ID],, ASC, DENSE )

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.