Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?

 

 

Best Regards

7 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Try

    Ranking =
RANKX (
    ALL ( 'Dim Grupo'[GRUPO_ABREV] ),
    CALCULATE ( SUM ( 'Fact total'[Primas emitidas] ) ),
    ,
    DESC,
    SKIP
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Does not work

       

       

      I want to keep the original value 

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        3 years ago

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