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

[Jilanibasha]

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.

[amitchandak]

@Jilanibasha , Based on what I got

Try a measure like

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

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[Jilanibasha]

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]

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

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