Forum Discussion

th3h0bb5's avatar
th3h0bb5
Resolver II
6 years ago
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...
Need Help
  • th3h0bb5's avatar
    th3h0bb5
    6 years ago

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

amitchandak's avatar
amitchandak
Super User
6 years ago

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

th3h0bb5's avatar
th3h0bb5
Resolver II
6 years ago

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