Top N Filters

Currently the only way to successfully develop against large data sets is hide them behind views. The within the view you use TOP N to limit the rows during development for speed. By comparison, Tableau has a feature that allows you to select ALL, TOP N or SAMPLE N when building the columnstore which is very useful.

You can do this already with RANKX () function. Atleast I have used this.

"Top 10" is so easy rather than creating new Measure = IF ( HASONEVALUE( .. ), RANKX( ALL (...) , CALCUATE ( ... ) and Filter.

We should have an ability to filter dataset on the report to show only for example top 5 records. In our scenario where we want to show top 5 queries sorted by execution time, we are able to prepare a table visualization, which shows all queries and their execution time, but not finding an option to filter top 5 queries based on execution time.

Some calculated fields may help? See http://ayadshammout.com/2013/02/19/dax-rankx-function-scenarios/

We should have an ability to filter dataset on the report to show only for example top N records. In our scenario where we want to show top 5 queries sorted by execution time, we are able to prepare a table visualization, which shows all queries and their execution time, but not finding an option to filter top 5 queries based on execution time.

Do you like bypass? If yes you gonna use RANKX. Top N is a stright feature for report users for which reports are created.

Similar to the Excel Top 10 Feature which only shows the top 100/10/5 items from a table in the visualization. https://www.youtube.com/watch?v=KkfH2pvI84s

Agreed. Filtering by "TOP" with an "Order By" would be most helpful.

Yes you can do this with Measure but would be nice if filter could just do it for you like in a Pivot Table in Excel.