Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Exclude slicer/filter from measure calculation

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

Need Help

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    6 years ago

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