Forum Discussion

EpicTriffid's avatar
EpicTriffid
Helper IV
1 year ago

Top 15 Values

Hi all,   I'm really beginning to lose my rag with RANKX and TOPN, or at least in trying to work out what I'm doing.   I want to be able to isolate the top 15 rows in my table, including the top ...
Need Help
uzuntasgokberk's avatar
uzuntasgokberk
Super User
1 year ago

Hello EpicTriffid ,

Can you change the dax code:

test =
RANKX(ALLSELECTED(RANKTEST[Course name]),CALCULATE(SUM(RANKTEST[2023])),,DESC,Dense)

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

EpicTriffid's avatar
EpicTriffid
Helper IV
1 year ago

Thank you for the suggestion, but the results are the same as the second screenshot I posted above. Ranking just doesn't seem to want to work on this data. To be clear, there are no additional filters on the table beyond the columns that you can see. The columns are Provider, Course Name, 2019, 2020, 2021, 2022, 2023.

  • uzuntasgokberk's avatar
    uzuntasgokberk
    Super User
    1 year ago

    Hello EpicTriffid,

     

    Sorry I forgot to add another your text column. Could you please use below the code:

    test =
    RANKX(ALLSELECTED(RANKTEST[Coursename],RANKTEST[ProviderName]),CALCULATE(SUM(RANKTEST[2023])),,DESC,Dense)

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |