Forum Discussion
mrclay82
Helper II
Helper IITOP N by value filtering options
Hi all, I have a matrix showing the 10 most profitable items. This is achieved with TOP N in the filter pane where a measure for [total profit] is the value in the TOP N filter. I would like ...
You could create a new measure, purely for use in the TOPN filter, which uses REMOVEFILTERS on the sales person column. That would filter the matrix to the top 10 products regardless of sales person, but would still allow the values within the matrix to be filtered to just the sales person selected in the slicer.
johnt75
Super User
Super UserYou could create a new measure, purely for use in the TOPN filter, which uses REMOVEFILTERS on the sales person column. That would filter the matrix to the top 10 products regardless of sales person, but would still allow the values within the matrix to be filtered to just the sales person selected in the slicer.
mrclay82Helper II
Helper IIMany thanks that solved it!