How to make get a max value independent of selection.

[#1]

Hi Friends,

I am using this line of code to get the max number of YearMonth. Right now it depends on the selection of the data and this causes some problems. I really wanted to make this only depend upon selected Metrics, selected Intervention but nothing else. How can I do it?

'Max({<'& only(%Metrics) & '={1}, ' & only(%Intervention) & '={0}>}YearMonth)'

Thanks.

[#2 · Accepted solution]

Try with this:

Max({1< %Metrics={1}, %Intervention={0} >} YearMonth)