topic Re: TOP N by value filtering options in DAX Commands and Tips

TOP N by value filtering options

mrclay82 — Tue, 05 Sep 2023 06:00:51 GMT

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!

Re: TOP N by value filtering options

johnt75 — Tue, 05 Sep 2023 09:24:01 GMT

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.

Re: TOP N by value filtering options

mrclay82 — Wed, 06 Sep 2023 06:26:01 GMT

Many thanks that solved it!