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

 

Many thanks

David

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 

     

     

5 Replies

  • 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