Keep ranking value with filter

[Anonymous]

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?

Best Regards

[johnt75]

Try

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

[Anonymous]

Does not work

I want to keep the original value 

[johnt75]

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

[Anonymous]

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.

[johnt75]

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.

[Anonymous]

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

[johnt75]

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