Can alternate states be used in functions within a set modifier?

[wdonckers]

Suppose a chart inherites 'State1' from the sheet it is located on.

We now want to build an expression that uses all selections of that state except for the year selection, that one should be from the default state.

I know the following works:     sum(<Year=$::Year>} Measure)

My question is however how to achieve the selection of the min or max value of Year of the default state.

So something like

sum(<Year={$(=min($::Year))}>} Measure)

Putting the '$::Year' inside a function like min() does not seem to work. Is there a solution?

Thanks,

Wim

[Gysbert_Wassenaar · Accepted solution]

Perhaps like this: sum(<Year={$(=min({$}Year))}>} Measure)

[wdonckers]

off course

Thanks.