DAX Measure to Return Top 10 Items

Joined
Mar 16, 2011
Messages
3
Reaction score
0
Points
0
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.
 

ruve1k

New member
Joined
Mar 22, 2011
Messages
4
Reaction score
0
Points
0
Check out the TOPN function.
technet.microsoft.com/en-us/library/gg492198(v=sql.110).aspx
 
Top