topic Use RANX with several filters in DAX Commands and Tips

Use RANX with several filters

Anonymous — Mon, 03 Apr 2023 14:33:35 GMT

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

rautaniket0077 — Mon, 03 Apr 2023 17:26:11 GMT

In DAX use group inside AllSelected.

MohammadLoran25 — Mon, 03 Apr 2023 17:36:37 GMT

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