Guitarmageddon
Board Regular
- Joined
- Dec 22, 2014
- Messages
- 159
Hello all,
I have a large table of sales data, and essentially I am taking each sku which is listed for each of the many locations it is selling at, and totalling it up to the parent "department" that it belongs to. I want to use dax to just show me the top 20% for each of the departments I have. How would I best do this? RANKX?
To complicate a bit more, I have multiple criteria that Im curious about. I have a column of future 90 days, past 90 days, and a couple others. Id like to see if there is some way for dax to say "if you were part of the top 20% in any of the columns of future, past, etc, to be marked as a top item". Does this make sense? Is this doable with dax inside a pivot table? I can sort of accomplish this is a conventional pivot table by sorting % to total by parent (in this case that parent department) then manually highlighting the items that comprise the top 20% movers, then isolating those out into a separate table. This is quite clunky when dealing with large numbers of departments however.
I have a large table of sales data, and essentially I am taking each sku which is listed for each of the many locations it is selling at, and totalling it up to the parent "department" that it belongs to. I want to use dax to just show me the top 20% for each of the departments I have. How would I best do this? RANKX?
To complicate a bit more, I have multiple criteria that Im curious about. I have a column of future 90 days, past 90 days, and a couple others. Id like to see if there is some way for dax to say "if you were part of the top 20% in any of the columns of future, past, etc, to be marked as a top item". Does this make sense? Is this doable with dax inside a pivot table? I can sort of accomplish this is a conventional pivot table by sorting % to total by parent (in this case that parent department) then manually highlighting the items that comprise the top 20% movers, then isolating those out into a separate table. This is quite clunky when dealing with large numbers of departments however.
