Results 1 to 3 of 3

Thread: DAX Measure to Return Top 10 Items

  1. #1

    DAX Measure to Return Top 10 Items



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,719
    Articles
    76
    Blog Entries
    14
    Hi Brandon,

    Maybe this will be of help? http://sqlblog.com/blogs/alberto_fer...owerpivot.aspx
    Ken Puls, CMA, MS MVP (Excel)

    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.

  3. #3


    Register for a FREE account, and/
    or Log in to avoid these ads!

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •