Forum Discussion

ChrisWilliams's avatar
ChrisWilliams
Advocate II
9 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
    9 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 ,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur,

 

Thanks for your help. It works on my mock data, but not working on my real data set which has 1.3M lines. Not sure why. I will spend some time tomorrow trying to trouble shoot. I just want to thank you first. 

 

PBISean

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

You are welcome.