Forum Discussion
Ignoring Included table filter while maintaining slicer filter
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.
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: