DAX Measure to Return Top 10 Items

[Brandon.Charlesworth]

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]

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]

Check out the TOPN function.
technet.microsoft.com/en-us/library/gg492198(v=sql.110).aspx