Forum Discussion

zhimingmar's avatar
zhimingmar
Regular Visitor
2 years ago

How to rank values using field parameters

Hi guys, 

 

Is there any way to rank values with field parameters?

For example, I have a dynamic filter created using field parameters (aging and state) and I'd like that the column rank could give me the rank ordered by the column 'indicador_vol_mdr'

 

I'm using this formula: 

Rank = RANKX(ALL('Dimensão 1 - Eixo X'[Dimensão 1 - Eixo X Campos]),[indicador_vol_mdr]) but it doesn't seem to work with this dynamic filter. 

 

3 Replies

  • JamesFR06's avatar
    JamesFR06
    Icon for Resolver IV rankResolver IV
    2 years ago

    Please try this ==>Rank = RANKX(ALLSELECTED('Dimensão 1 - Eixo X'[Dimensão 1 - Eixo X Campos]),[indicador_vol_mdr])

    • zhimingmar's avatar
      zhimingmar
      Regular Visitor
      2 years ago

      Hi James, I tried with allselected and it returned me the same result.

      I don't know if the problem is that the formula does not understand the field I'm using ('Dimensão 1 - Eixo X'[Dimensão 1 - Eixo X Campos]) that comes from field parameters.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, zhimingmar 

        Can you provide a PBIX file that does not contain private data? What is the format of your parameters?  

         

         

         

        How to Get Your Question Answered Quickly

        If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

        Best Regards

        Jianpeng Li