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