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)
Greg_Deckler's avatar
Greg_Deckler
Community Champion
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)