Measure to ignore one filter ie Year = 2014 when filter for year 2013 is selected

[RJ]

Hi

I want to lock a Year = 2014 measure

I have tried two measures

Sales2014b = SUMX( FILTER( (InvLines), RELATED(InvHeader[Year] ) = 2014), ( InvLines[SalesValue]))

and

Sales2014 = if (related(InvHeader[Year]) = 2014 , InvLines[Invoiced Quantity] * InvLines[OrderPrice] * (1 - InvLines[Line Discount %]) * (1- RELATED(InvHeader[Invoice Discount %])))

Both give the same correct result. But when I filter Year = 2013 it blanks the 2014 column out. I want to keep this value but only exclude this one filer. All the other filters should apply.

Qlik can do this using set analysis but I just can not work out how to do it in Power BI. I've tried "all" and it didn't work

Thanks for any assistance

[RJ · Accepted solution]

ok

This seems to work

Sales14 = CALCULATE(sum (InvLines[SalesValue]), InvHeader[Year] = 2014)