Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be try this
=if(Match([MeasureID], 1, 2), sum({$<Variable={'a'}>} [Numerator]),
if(Match(Only({<Year>} [MeasureID]), 3), only({$<Variable ={'a'}, Year= >} [Numerator])))
May be try this
=if(Match([MeasureID], 1, 2), sum({$<Variable={'a'}>} [Numerator]),
if(Match(Only({<Year>} [MeasureID]), 3), only({$<Variable ={'a'}, Year= >} [Numerator])))
Thanks Sunny, this worked perfectly!