Set Analysis - need to always get a value for the max month

[#1]

Expression is this:

Sum({1<YEAR_MONTH={'$(=MaxString(YEAR_MONTH))'},METRIC_NAME={'X'},COMPANY_NAME={'Y'}>}METRIC_QUANTITY)

I want this measure to always be the sum of the value for the most recent month in the data when the conditions X and Y are met.

The above works except that it changes as date selections change.  It needs to remain static.  I'm sure that there is some syntax that I'm missing.

Thanks!

[sunny_talwar · Accepted solution]

Try this:

Sum({1<YEAR_MONTH={'$(=MaxString({1}YEAR_MONTH))'},METRIC_NAME={'X'},COMPANY_NAME={'Y'}>}METRIC_QUANTITY)