Forum Discussion
Solved
Tiered Ranking
Hello Community! I am endeavoring to rank clients in relationship to their peers. I have data like so: Overall Rank just uses RANKX() but for TierRank, I want the rank of each client onl...
Thanks for the links! The DAX you sent didn't work for me, but I pulled this from the Radacad blog and it works fine:
RANKX(
FILTER(
'Table',
'Table'[Category]=EARLIER('Table'[Category])
),
'Table'[My Value]
)
You can try Sub Category Ranking
Like Rankx(All(Table[Tier],sum(Table[Shipment]),,desc,dense)
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-ye5L