topic How to rank values using field parameters in DAX Commands and Tips

How to rank values using field parameters

zhimingmar — Tue, 05 Mar 2024 18:39:04 GMT

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.

Re: How to rank values using field parameters

JamesFR06 — Tue, 05 Mar 2024 21:40:44 GMT

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

Re: How to rank values using field parameters

zhimingmar — Wed, 06 Mar 2024 11:29:38 GMT

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.

Re: How to rank values using field parameters

Anonymous — Wed, 13 Mar 2024 09:45:24 GMT

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