View Full Version : DAX Measure to Return Top 10 Items

2011-04-06, 11:31 PM
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
2011-04-07, 07:30 AM
Hi Brandon,

Maybe this will be of help? http://sqlblog.com/blogs/alberto_ferrari/archive/2011/01/11/dynamic-ranking-with-excel-and-powerpivot.aspx

2012-01-24, 05:39 AM
Check out the TOPN function.