Forum Discussion

ChrisWilliams's avatar
ChrisWilliams
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Rankx with filter

I'm working on a RANKX function that involves a filter.  I reviewed this answer, but it did not seem to help my scenario.   I have a table called "UserMessages", and a simplified version is shown b...
Need Help
  • Vvelarde's avatar
    Vvelarde
    10 years ago

    hi ChrisWilliams

     

    Rank Top Senders =
RANKX (
    FILTER ( ALL ( UserMessages ); UserMessages[Direction] = "Outbound" );
    CALCULATE (
        SUM ( UserMessages[Messages] );
        ALLEXCEPT ( UserMessages; UserMessages[User] )
    );
    ;
    DESC;
    DENSE
)

     

    replace ; with ,

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

hi ChrisWilliams

 

Rank Top Senders =
RANKX (
    FILTER ( ALL ( UserMessages ); UserMessages[Direction] = "Outbound" );
    CALCULATE (
        SUM ( UserMessages[Messages] );
        ALLEXCEPT ( UserMessages; UserMessages[User] )
    );
    ;
    DESC;
    DENSE
)

 

replace ; with ,

ChrisWilliams's avatar
ChrisWilliams
Icon for Advocate II rankAdvocate II
10 years ago

 Thank you Vvelarde, that works perfectly.  I'll have to study up on AllExcept... I haven't seen that used in Ranking before but it works well.