Exclude slicer/filter from measure calculation

[Anonymous]

HI,

I have two matrix that interact with each other. Due to this matrix- 2 is having a filter like below

now I have a measure

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

But the date=12/31/2013 filter is getting applied and i'm not getting required result. This filter happened due to interaction and was not created by me. Is there a way I can remove that filter while calculating the measure.? I cannot turn of intercation because of other columns in the table

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may use "Edit interactions" feature to determine which visual be effected by another visual following steps below. See the similar case .

You can learn more: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards,

Amy 

Community Support Team _ Amy

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

[MFelix]

HI @Anonymous ,

Without any data or example is difficult to give an answer but you can try to add something similar to this:

AnalysisDateAmount =
CALCULATE (
    SUM ( Table_1[Amount] ),
    FILTER (
        ALL ( Table_1[File Category] ),
        Table_1[File Category] = "Analysis Date"
    ),
    ALL ( Table[Date] )
)

Or

AnalysisDateAmount =
CALCULATE (
    SUM ( Table_1[Amount] ),
    FILTER (
        ALL ( Table_1[File Category] ),
        Table_1[File Category] = "Analysis Date"
    ),
    ALLSELECTED ( Table[Date] )
)