Dynamic Top N

[ADP007]

Hi all,

I have seen several examples with a dynamic top N but I just can't seem to get it working in my report.

Could someone have a look at my example mScore_topN.pbix at the following link ? mScore 

Many thanks

David

[lbendlin · Accepted solution]

change your TopN measure to 

TopN = if([RANK] <= SELECTEDVALUE('Top N'[Top N]),1,0)

and then filter your visual by TopN = 1 

[ADP007]

Hi @lbendlin 

This is great many thanks.

I'm not very good with DAX. Any idea how I could also add a Bottom N filter ?

Thanks

David

[lbendlin]

Run a MAXX over the RANKX and then subtract the rank from the result. That makes the BottomN behave like the TopN.

Watch out for performance issues with large lists.

[ADP007]

Thanks @lbendlin 

I'll keep that in mind. For the moment I have duplicated the table and added a top n and bootom n. This way they can compare the top and the bottom at a glance.

Thanks for your reply

[manikumar34]

@ADP007 ,

Use what if analysis with incremant of 1 for N filter.

Regards,

Manikumar