Ignore selection in a if match expression

[Anonymous]

I have multiple measures that I have combined in one loaded table, but some have multiple years and some are for a fixed year.

In my table I am trying to make the data which has multiple years selectable but those which do not will be fixed and not change regardless of whether a year is selected in the multi box.  I can get the data to display using the following if match statement but MeasureID 3 disappears when I select a year combination it doesn't have associated with it:

=if(match([MeasureID],1,2),sum({$<Variable={'a'}>}[Numerator]),
if(match([MeasureID],3),only({$<Variable ={'a'}>}[ Numerator])))

I tried the following to ignore the year filter, but it just makes MeasureID 3 go blank:

=if(match([MeasureID],1,2),sum({$<Variable={'a'}>}[Numerator]),
if(match([MeasureID],3),only({$<Variable ={'a'}, Year= >}[ Numerator])))

Is this possible?

[sunny_talwar · Accepted solution]

May be try this

=if(Match([MeasureID], 1, 2), sum({$<Variable={'a'}>} [Numerator]),
if(Match(Only({<Year>} [MeasureID]), 3), only({$<Variable ={'a'}, Year= >} [Numerator])))

[Anonymous]

Thanks Sunny, this worked perfectly!