HELP dax rankx

Hello yforti13 ,

You can try this measure

RankingTableCNE180d =
VAR _x =
RANKX(
...
CALCULATE(
[r_CNE180d],
'd_Calendario'[Date] >= DATE(2025, 02, 01),
'd_Calendario'[Date] <= DATE(2025, 02, 29)
)
)
...
RETURN
SWITCH(TRUE()

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Hi yforti13 ,

You cannot directly sort any specific column in matrix.
Using the sort functionality in matrix it will sort for the entire data and not for a particular column.

However, if you wish to achieve this by using RANK function, you can refer this solution:

https://community.fabric.microsoft.com/t5/Desktop/Top-N-Ranking-for-specific-year/m-p/2122020#M785126

Hope this helps!

Hi yforti13 ,
I hope this information was helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

Hi @yforti13 ,
I hope this information was helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

Hi @yforti13 ,
I hope this information was helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.