Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
4 years ago

Filter a rankx

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

 

Need Help

5 Replies

    • nicolast29's avatar
      nicolast29
      Icon for Helper V rankHelper V
      4 years ago

      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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

    • v-yalanwu-msft's avatar
      v-yalanwu-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      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.