PDA

View Full Version : DAX Measure to Return Top 10 Items



Brandon.Charlesworth
2011-04-06, 10: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, 06: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

ruve1k
2012-01-24, 04:39 AM
Check out the TOPN function.
technet.microsoft.com/en-us/library/gg492198(v=sql.110).aspx