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 do...
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 ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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.