Use RANX with several filters

[LD1]

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

[MohammadLoran25]

Hi @LD1 ,

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

[rautaniket0077]

In DAX use group inside AllSelected.