Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use RANX with several filters

Before the selection in segment (Marque commerciale)  : Top rank works :

 

And when i select one of "Group" in segment, it doesn't work : 

 

 

 

How can i modify the formula RANKX with several filters (segment) ? 

 

rang N TOP CA = RANKX(ALLSELECTED('Sectors[Sectors]),CALCULATE([CA N DATE (m)]),,DESC)

 

Thank you in advance for your help !

 

Léna

 

DAX

2 Replies

  • MohammadLoran25's avatar
    MohammadLoran25
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Anonymous ,

    I think your Group column is in a separated table (lets call it GroupTable) which is connected to Sectors Table. If Yes,

    Follow steps below:

     

    1-Create a calculated column in your Sector Table:

    RELATED('GroupTable'[Group])

     

    2-Then Put the previous calculated column in your Slicer as your group filter.

     

    Then it works as you expect.

     

    If this answer solves your problem, please mark it as an accepted solution and gives it a thumbs up so the others would find what they need easier.

    Regards,
    Loran