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.

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

        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.