Forum Discussion

csaethre19's avatar
csaethre19
Icon for Helper II rankHelper II
3 years ago
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...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    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.

csaethre19's avatar
csaethre19
Icon for Helper II rankHelper II
3 years ago

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?

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

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.

  • csaethre19's avatar
    csaethre19
    Icon for Helper II rankHelper II
    3 years ago

    Thank you this works for me!