Filter a rankx

[nicolast29]

Hi

On My report i can choice a combinaison of criteria

- N° de dossier (with a slicer on the top on the right)

- With a choice in a table (thoses from the left)

So i want now to make a rank like this (I create the measure)

Pareto Partie 1 - Rank = RANKX(DISTINCT(ALLSELECTED('fusion Balances Ts Dos'[Compte 8c])),[Solde N])

It works, but return (logical) the dat from all the exercices (fusion Balances Ts Dos[Exercice])

and dossiers (fusion Balances Ts Dos[N° de Dossier])

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

I try different way using selectedvalues or filter in my measure, i also try to create a dedicated table, but without good result

Can you help me please

https://1drv.ms/u/s!AoqtZHsX4BzvhINiGN693yLH6yOBbg?e=JOrd5W

[nicolast29]

i was rong with my research, i finally arrive with 2 measures

https://1drv.ms/u/s!AoqtZHsX4BzvhINiGN693yLH6yOBbg?e=mUN0o5

Thanks for answering

[v-yalanwu-msft]

Hi, @nicolast29 ;

So did you solve your problem? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case.  thank you.

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.

[v-yalanwu-msft]

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.

[amitchandak]

@nicolast29 , Are you looking something like TOPN where N is coming from the slicer 

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[nicolast29]

thanks for your link, 

for me no, because the slicer return a name in my case and i use the table Mapping nom numéro dossier to translate to the number of the dossier

that is this number and the exercice = N that i want to use