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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Ivan_lopez
Frequent Visitor

Keep ranking value with filter

Hello Community,

I am trying to represent the global ranking position for an entity and I get it. But when I want to show only one of the entities the ranking value becomes 1. I understand why it does this, but I don't manage to keep its actual position in the ranking even if I am filtering the visual by a single entity.

Can this be done?

 

Ivan_lopez_0-1671532078141.png

 

Best Regards

7 REPLIES 7
johnt75
Super User
Super User

Try

Ranking =
RANKX (
    ALL ( 'Dim Grupo'[GRUPO_ABREV] ),
    CALCULATE ( SUM ( 'Fact total'[Primas emitidas] ) ),
    ,
    DESC,
    SKIP
)

Does not work

 

Ivan_lopez_1-1671538810775.png

 

I want to keep the original value 

Are there any other columns in your table visual, as opposed to measures ?

The "Premium Ranking (Product Ranking)" is the metric with the overall ranking. The second ranking metric is the DAX metric I have attached above and finally, "Ranking (community)" is the metric that contains the code you have provided me.

Is it possible to share a PBIX with any confidential information removed ? I've tried the code I wrote against one of my models and it seems to work correctly.

I'm sorry, I'm afraid that's not possible.

 

If I use the metric you have provided me and if you filter by one of the categories that form "GROUPS_ABREV" the value it takes is 1 because it is the only row that is showing

Can you post the query generated for the table visual from Performance Analyzer? 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.

Top Solution Authors