Rank not working

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