Forum Discussion
Top X with filter
I have too done it with RANKX. Check out this article:
http://www.daxpatterns.com/parameter-table/
Scroll to the section called Limit Top N Elements in a Ranking for an example where the N is dynamic (but then you may set it to 10 internally).
While I do not currently have a sample available, I have successfully completed this by creating a RANKX based upon product performance and adding a filter to only show the top (or bottom) 25. As the slicers are selected the RANKX retains numerical order but filters out those that are not int he top performers.
You may also be able to use a version of TopN
I have too done it with RANKX. Check out this article:
http://www.daxpatterns.com/parameter-table/
Scroll to the section called Limit Top N Elements in a Ranking for an example where the N is dynamic (but then you may set it to 10 internally).
I like the pattern in this article.
Additionally, you can vote for native top n filters in Power BI here.
