The calculation is working properly. However, when you add complex table calculation which needs to be computed in certain ways to the title, then it starts getting complicated.
A workaround is to create a second worksheet which is exactly like the parent worksheet with ALL the filters applied to both worksheets. Then use a calculated field to display the text.
On the dashboard, turn off title and instead use the second worksheet as the title. All the table calcs in second worksheet are computed along Year.
Because Year is in the view, I have used LAST() == 0 to filter the text to just the last year.
Hope this helps.
Spending v Adequacy_OO_v10.4.twbx 155.6 KB