CODEWITHSUNDEEP
powerbidax
vandelay
vandelay

Reputation: 2065

Possibility for a measure to ignore slicers in powerBI without editing interactions

As the title says, is it possible for a measures values not to change by any means? It's not possible for me to edit interactions with the slicer as the graph contains other measures.

F.eks. If I have a Slicer with dates December, January and February, and I select January the measure should still show data for all 3 months.

I'm hoping there's some DAX function which allows this.

Upvotes: 1

Views: 36135

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

Yes, you can set the filter context within a measure.

For example, if you had a calculation that summed revenue,

= SUM(Sales[Revenue])

Then you could modify it to look something more like this:

= CALCULATE(SUM(Sales[Revenue]), ALL(Sales[Date]))

This would clear the slicer's filter and return the sum over all dates.

Upvotes: 2

Related Questions