Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
Solved

Rank not working

Hi, I am trying to rank clientId by the measure "2024 YTD" but i am getting all 1s. So the rank is not working as expected.   The defintion of my rank is as follows: RankClients =...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi mp390988  ,
    Thanks for reaching out to the Microsoft fabric community forum.

    Please create a separate Table visual in your report and add only the 2024YTD and RankClients measures to it. This will help you determine whether the issue is with the measure logic itself or caused by unintended filters or interactions applied elsewhere in the report. By isolating the measures in a clean context, you can more easily pinpoint the root cause.

    Additionally try modifying your DAX in such a way and check if the issue still persists

    RankX_2 = 
VAR t = CALCULATETABLE(RankClients, REMOVEFILTERS(RankClients), VALUES(TradesTbl[ClientID]))
RETURN RANKX(t, [RevenueYTDForPrevYear] )



    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

Greg_Deckler's avatar
Greg_Deckler
Community Champion
1 year ago

mp390988 Can you share some sample data as text? Hard to know what exactly is going wrong. You might check out the RANK function as well as it can sometimes be less finicky than RANKX. You could also try an alternative to RANKX found here: To *Bleep* with RANKX! - Microsoft Fabric Community