Maybe this will be of help? http://sqlblog.com/blogs/alberto_fer...owerpivot.aspx
Has anybody created an DAX measure to return the top 10 items. For example I am looking to return the top 10 items by sales dollars.
I know this can be done in a pivot table but I need to have multiple days of information and the pivot table will be to large, making using the file inefficient.
Ken Puls, FCPA, FCMA, MS MVP (Excel)
Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Check out the TOPN function.