Forum Discussion
Ignoring Included table filter while maintaining slicer filter
Hello,
I am attempting to compare individual performance against the average performance of a group using a line chart.
However I want the user to be able to deselect certain people, to filter out unwanted data. The idea is the list of people will be selected in the slicer, their stats will appear in the table. Selecting a name from the table will filter the line chart to that person's stats. Example included.
However, now I've selected the employee to review, I'd like to create an Average line across the other 3 employees who were chosen in the slicer, but are not currently selected. I cannot use ALL() or REMOVEFILTERS() on the [First Name] column since doing so would include Josh.
Is there some way to remove the "Included (1)" filter from the table, while keeping the rest? Or is there a better approach to what I am trying to do?
Thanks!
Disconnected tables are your friend here. I'm not 100% sure what your data looks like behind all of it, but here's my setup -
(btw there's no relationship between the tables)
I put Name[Name] in a slicer, I then create 2 measures:
All selected names = CONCATENATEX(ALLSELECTED(Names[Name]), Names[Name], ", ") // this is all the names selected in the slicerexcluding slicer Names = CONCATENATEX(EXCEPT(ALLSELECTED('Names'[Name]), ALLSELECTED('Names (2)'[Name])), 'Names'[Name], ", ")which gives the following result:
instead of using concatenatex, you could save the values in a variable, and use them as calculate filter arguments.
2 Replies
Disconnected tables are your friend here. I'm not 100% sure what your data looks like behind all of it, but here's my setup -
(btw there's no relationship between the tables)
I put Name[Name] in a slicer, I then create 2 measures:
All selected names = CONCATENATEX(ALLSELECTED(Names[Name]), Names[Name], ", ") // this is all the names selected in the slicerexcluding slicer Names = CONCATENATEX(EXCEPT(ALLSELECTED('Names'[Name]), ALLSELECTED('Names (2)'[Name])), 'Names'[Name], ", ")which gives the following result:
instead of using concatenatex, you could save the values in a variable, and use them as calculate filter arguments.
Great! Got it working, and learned something new. Thank you!
And to any that come looking at this in the future, to make this work with a measure I did this:
