How to avoid a filter to influence a key measure

[Anonymous]

Hello,

In a chart line, the x axis is the date while the y axis, I have two following measures:

Previous Year Hit Rate = CALCULATE ( [Hit Rate], FILTER( 'Summary Table',value( [Fiscal Year]) = [Previous Year]))

Current Year Hit Rate = CALCULATE ( [Hit Rate], FILTER( 'Summary Table', value([Fiscal Year]) = [CurrentYear] ))

I would like to add two more variable

Previous Year Hit Rate for selected lockbox = CALCULATE ( [Hit Rate], FILTER( 'Summary Table',value( [Fiscal Year]) = [Previous Year] && 'Summary Table'[LockBox]=SELECTEDVALUE('Map Lockbox Color'[LockBox])))

Current Year Hit Rate for selected lockbox = CALCULATE ( [Hit Rate], FILTER( 'Summary Table',value( [Fiscal Year]) = [CurrentYear] && 'Summary Table'[LockBox]=SELECTEDVALUE('Map Lockbox Color'[LockBox])))

However, when I apply the filter to the line chart, the two first key measure (Previous Year Hit Rate, Current Year Hit Rate) are influenced by the filter.  What Can I do to avoid that?

[Greg_Deckler · Accepted solution]

Use REMOVEFILTERS on the first two measures to get rid of the 'Map Lockbox Color'[LockBox]) filter?