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

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        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