Forum Discussion

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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

You may drag Customer Name to the row labels and then in the Visual level filters, uncheck the blank in the Customer Name field.  Write these measures

 

Total Sales = SUM(Data[Sales])

Rank of selected Customers = RANKX(ALLSELECTED(Data[Customer Name]),[Total sales])
 
Hope this helps.
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.