Forum Discussion
Solved
Dynamically filter measure based on slicer value
I am trying to create a measure that will be affected by a slicer that is selected. I have two measures that need to be affected by different slicer filters on one page, hence why I am not just syn...
For the measure which needs to ignore 2 of the slicers you can use REMOVEFILTERS to ignore filters on the particular table or column used in the slicers.
That is what I was doing before. However, I have two measures that need to be used in a visual. One of which needs to be affected by 6 of the 8 slicers I have. The other measure needs to be affected by all 8 slicers. Does that make more sense?
For the measure which needs to ignore 2 of the slicers you can use REMOVEFILTERS to ignore filters on the particular table or column used in the slicers.
Thank you this works for me!