CALCULATE while ignoring 1 filter and identifying a table filter

[Anonymous]

Hi, 

I`m trying to create a sum using CALCULATE that ignores filters from a certain column (a certain slicer) but I also need to identtify a filter from other column within the CALCULATE.

What I have now: 
Measure=

CALCULATE(SUM('view'[Value]),FILTER('view','view'[Y/N]="Y"))
This is affected by my slicer which is YEAR.
How can I change this measure to not be impacted by the YEAR slicer?

Edit:
I can also use this to ignore the filter but then lose my [Y/N] Filter:
CALCULATE(SUM('view'[Value]),All('view'[YEAR])

I guess the question becomes, how to combine these two measures?

[tamerj1 · Accepted solution]

Hi @Anonymous 

you can use both

=
CALCULATE (
SUM ( 'view'[Value] ),
KEEPFILTERS ( 'view'[Y/N] = "Y" ),
ALL ( 'view'[YEAR] )
)