Create a filter that allows me to say 'Show the top N categories by value', e.g. 'Top 5 countries by sales'
266 Comments
- 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.
