Forum Discussion

natti_plis's avatar
natti_plis
Frequent Visitor
2 years ago
Solved

How to exclude rows from the dynamic RANX metric?

Hi! I need help with the RANKX function. I have one ranking on the fly, that works perfectly on the items that are selected ->> duel_rank =     RANKX(ALLSELECTED(smb_pbi_input[Identifier]), CALC...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    natti_plis Can you provide a link to a sample file. This seems very doable.

    duel_rank =
    RANKX(FILTER(ALLSELECTED(smb_pbi_input[Identifier]), [prod_type] = 2), CALCULATE( sum (smb_pbi_input[xxx])), ,ASC)
natti_plis's avatar
natti_plis
Frequent Visitor
2 years ago

Hi Greg_Deckler 

You're my hero of the day ❤️

It's working perfectly and looks so simple! I've tried doing something similar in many ways, but I had to miss a detail or use the wrong order of functions. After looking the whole day at this report I had reached a dead end. 

 

Thank you so much, and have a great weekend!

Natalia