Forum Discussion

mrclay82's avatar
mrclay82
Icon for Helper II rankHelper II
3 years ago
Solved

TOP 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 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's avatar
    johnt75
    3 years ago

    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.

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    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.