Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Ranking with multiple filters

Hi I have a table and I want to rank ONLY the instances of userIDs where statusofResponse is 1 and ResponseID is 99. Here is the table and here is the desired output: UserID ResponseID Response...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Try:

     

    Rank = 
    IF([StatusofResponse] <> 1 || [ResponseID] <> 99,
        BLANK(),
        RANKX(FILTER('Table',[StatusofResponse] = 1 && [ResponseID] = 99 && [UserID] = EARLIER([UserID])),[Response Value])
    )

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Try:

 

Rank = 
    IF([StatusofResponse] <> 1 || [ResponseID] <> 99,
        BLANK(),
        RANKX(FILTER('Table',[StatusofResponse] = 1 && [ResponseID] = 99 && [UserID] = EARLIER([UserID])),[Response Value])
    )