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 

     

     

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