How to rank values using field parameters

[zhimingmar]

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. 

[JamesFR06]

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

[zhimingmar]

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]

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