I want to limit the choices to just the last 5 years.
Now in other expressions I want to ignore this choice when it is made. But since it is calculated I can't reference it in the Set Analysis by just the field name,TerminationDate.autoCalendar.Year like I can with other filters that are just a field.
So how can I add this filter to my list of filters that I want to ignore in my Set Analysis?
I think the problem is not the calculated measure, but the autoCalendar field... It seems that autocalendar fields cannot be used within set analysis to ignore selection. May be create a Year field and then try to see if that works