TOP N by value filtering options

[mrclay82]

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 to add a slicer for “sales person”, so that each sales person can select themselves and see if they have any items in the matrix.

The issue is that if a sales person select themselves the whole matrix is filtered with the TOP 10 most profitable items for THAT salesperson.

I have tried to set the same TOP N filter for the slicer with no success.

What am I missing here? Field parameters is not an option here due to company restrictions.

Thanks!

[johnt75 · Accepted solution]

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.

[mrclay82]

Many thanks that solved it!