Top N Filters

[pbiideas1]

Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'

[james_snape1]

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.

[jormto]

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

[yoshihiro]

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

[fbcideas_migusr]

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.

[kirk_potter]

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

[fbcideas_migusr]

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.

[kolar3]

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

[PowerBuffalo]

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

[mkimsey]

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

[tkale]

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.