Forum Discussion

ADP007's avatar
ADP007
Helper IV
5 years ago
Solved

Dynamic Top N

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 ? m...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    change your TopN measure to 

     

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

     

    and then filter your visual by TopN = 1 

     

     

lbendlin's avatar
lbendlin
Super User
5 years ago

change your TopN measure to 

 

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

 

and then filter your visual by TopN = 1 

 

 

  • ADP007's avatar
    ADP007
    Helper IV
    5 years ago

    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

    • manikumar34's avatar
      manikumar34
      Solution Sage
      5 years ago

      ADP007 ,

       

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

       

      Regards,

      Manikumar

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      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's avatar
        ADP007
        Helper IV
        5 years ago

        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