Exclude slicer selection from the results

[dokat]

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 do that? Appreciate any help!

Slicer 1; Period

Slicer 2: Channel

Slicer 3: Category

Slicer 4: Segment

[dokat · Accepted solution]

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

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

[Syk]

Click on your slicer and find the format tab in the ribbon, select edit interactions and hit the circle with the line through for the measure you don't want to change with the slicer

The slicer will no longer affect the value (changed dates here)
Before:

After:

[dokat]

@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]

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.