Exclude slicer/filter from measure calculation

[Anonymous]

Hello

I have two arrays that interact with each other. Because of this matrix- 2 is to have a filter like the following

now I have a measure

AnalysisDateAmount a CALCULATE (
SUM ( Table_1[Amount] ),
FILTER (
ALL ( Table_1[File Category] ),
Table_1[File Category] - "Date of Analysis"
))

But the date filter 12/31/2013 is being applied and I am not getting the required result. This filter occurred due to interaction and was not created by me. Is there a way to remove that filter while I calculate the measure.? I can't turn off the interction because of other columns in the table

[v-diye-msft]

Hi @Anonymous 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.