Forum Discussion
Getting a Pivot to ignore zero values in Top 10 filter
I have a number of pivots that make up a sales report. Within that I have top and bottom 10 filters to focus on the main challenges/opportunities However, using Top 10 if the sales person (a...
Creating the PivotTable you may add data to data model and create DAX measure as
sumB:=VAR sm=SUM(Table1[B])
RETURN IF(sm=0, BLANK(), sm)
for such sample model
apply Top 10 filter to it and set proper sorting.