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,an...
Need Help
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)

    • Jilanibasha's avatar
      Jilanibasha
      Frequent Visitor
      5 years ago

      Hi Amit,

       

      ContactTopic[tie] column not there

      if i remove that column now it is same as my formulae only.

      that formula not working. Please suggest limit the tie rank number of rows