PDA

View Full Version : Only show top N items for given filter selection



Spencer_2
2016-12-29, 05:29 PM
Maybe the obvious is evading me... What is the best method to accomplish the following in Power Pivot:

Only show "items" that comprise 80% of a sales value for a given filter selection. i.e. East, West, South, etc.

Right now I'm simply using "SHOW TOP 20" in the Pivot Table Value Filter.

This ends up showing more items than a straight 80% of sales. I have been playing with Calculate and Filter options but not success yet.

Thanks for any tips...

Spencer_2

Owen Auger
2016-12-29, 11:16 PM
Hi Spencer_2

Have a look at:
http://www.daxpatterns.com/abc-classification-dynamic/

You might want to use the measure in the section "Dynamic Classification on Page-Filter Level".

Note, that page was written without the use of DAX variables.

Spencer_2
2017-03-07, 12:12 AM
Just read thru this... Good stuff but a bit more complex than my current situation demands. Thanks for the tip.
Spencer