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 giv...
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