Tiered Ranking

[th3h0bb5]

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 only against other clients in their tier.

[amitchandak]

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-y...

[th3h0bb5 · Accepted solution]

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]
)