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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Does this measure work?

RankClients = RANKX(GENERATE(GENERATE(ALL(TradesTbl[ClientID]),ALL(TradesTbl[ClientName])),ALL(TradesTbl[DealerID]),ALL(TradesTbl[DelaerName]))[RevenueYTDForPrevYear],,DESC,Dense)

If this does not work, then share the download link of the PBI file.