Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Exclude slicer selection from the results

Hi,   I have a report with 4 slicers. I'd like to create a measure where it sums regardless of the slicer selection. I'd like to completely exclude any slicer selection from the results. How can i ...
Need Help
  • dokat's avatar
    dokat
    4 years ago

    I found the solution all() function did the trick for me and excluded all slicers.

     

    Calculate(SUM('POS'[Values]),'POS'[Measures] IN {"Dollars"},ALL())

     

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago

Syk Thank you for your response. There are some calculations i'd like it to interact with the slicer selections in the same table. I don't want to exclude all interactions. Is there a way to do this?

Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
4 years ago

You'd need to use a filter function that overides the context of the report page.. Calculate is an example of this - in this screenshot the table still takes interaction from the date slicer but the 'New Measure' doesn't care because it uses calculate to overide it.