Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
zhimingmar
Regular Visitor

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'

 

zhimingmar_0-1709663666048.pngzhimingmar_1-1709663739310.png

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 3
JamesFR06
Resolver IV
Resolver IV

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

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

zhimingmar_0-1709724441130.png

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
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.