Filter the visual of a running total without filtering the underlying data

[LoicIDCC]

Hello,

I created a running total that calculates the count of distinct values by dates (using ISONORAFTER to manage the blank values):

Cumulative =

CALCULATE(DISTINCTCOUNT(Data[PATT_ID]), FILTER( ALLSELECTED('CALENDAR'),ISONORAFTER('CALENDAR'[Date],MAX('CALENDAR'[Date]),DESC)))

I want to create a slicer to filter the visual to certain years but not filtering the underlying running total.

I have tried to create a third calendar table for the visual and link to the calendar table, but that doesn't work.

Any idea how I can do that?

Thanks!

 

[v-janeyg-msft · Accepted solution]

Hi, @LoicIDCC 

The slicer is originally used to filter the visual effects, and it doesn't affect the underlying data. 

If there is a measure in the visual that is affected by the slicer, you can choose to change 'allselected' to 'all' or edit interactions in the visual format.

Reference: Change how visuals interact in a report - Power BI | Microsoft Docs

If you still need help, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.