Filter a rankx

Hi, nicolast29 ;

Can you share the results you want to output? There's a lot of data. I'm a little confused.

I want to filter my rank with the number of the dossier selected and to force one criteria the Exercice to "N"

As you wish to implement according to your choice... This must be dynamic data, right? Because your slicer selection is different, its ranking and results are also different;
However, if we create a new table, it is a static table, so we cannot display different dynamic tables according to different choices. We can only use Measure to achieve this.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.