Forum Discussion
Solved
Need Help in RANK DAX function (Dynamic Ranking)
I have the following in which I have to do dynamic Ranking. First, it should see the region and then based on Total sales When the region changes, it should start again from 1, (Similar to partitio...
DAX formula:
Dynamic_Rank =
RANKX(
FILTER(
'YourTableName',
'YourTableName'[Region] = EARLIER('YourTableName'[Region])
),
'YourTableName'[Total Sales],
,
DESC,
Dense
)
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande
DAX formula:
Dynamic_Rank =
RANKX(
FILTER(
'YourTableName',
'YourTableName'[Region] = EARLIER('YourTableName'[Region])
),
'YourTableName'[Total Sales],
,
DESC,
Dense
)
If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande