Forum Discussion

Jilanibasha's avatar
Jilanibasha
Frequent Visitor
5 years ago

Issue with Ranking, Sharing same rank with multiple labels due to tie rank.

Hi Team,

 

I have an issue with Ranking, i have applied rank on Topics based on topic count. For Top ranking there are different values its so it is working fine. For bottom ranking, rank 1,2,34,and 5th rank tie with multiple topics. 

Ex. 1 is tie with 200 topics and 2 is tie with 100 topics..... like that,

my requirement is, if same rank sharing with multiple topics, instead of showing all the topics i need to restrict 20 topics(rows).  

below is the my current scenario 

Please help some one how to restrict topics 20 or 30 is fine with coustomer. he doent want to see visutal like this.

 

 

Need Help

4 Replies

    • Jilanibasha's avatar
      Jilanibasha
      Frequent Visitor
      5 years ago

      Hi amitchandak ,

      currently below measure is used to calculate bottom values.

      RANKX(ALLSELECTED(ContactTopic[topic]) ,CALCULATE(COUNT(ContactTopic[topic])),,ASC,Dense).

       

      but in your formulae

      rankxs(allselected(Table[tie]), Table[Topic]), Calculate(count(Table[Topic])),,desc,dense)

      i did not understad "Table[tie]", is it calculted measure? what is the formulae for it, and how can it control the rows only 20.

       

      • amitchandak's avatar
        amitchandak
        Super User
        5 years ago

        Jilanibasha , Sorry, some typos, Done some modification, check if that can work, if you have both columns

         

        rankx(allselected(ContactTopic[tie], ContactTopic[Topic]), Calculate(count(Table[Topic])),,desc,dense)