Thanks for sending in the question with the workbook. I had a play with it, but I have to be honest, I got a bit lost in your calculations and couldn't follow them so I didn't really see where they stopped working.
I had another play with how I would solve the problem if asked from scratch. My approach is quite different but I think I get the same results. The final indicator if all targets are met (Performance: Good or Bad) does seem to work correctly when filtering or putting in different columns.
However after that I got lost again in what the data means.
Hahaha - sorry it is a bit of a chaotic answer, but I hope it helps you further.
Sustained growth v7 - different.zip 366.2 KB
Many thanks for taking the time to go into the dashboards with lot of calculations. I think your calculations might go faster than my calculations using LOOKUP.
I think if I remove the filter condition on other parts of the sheet, it works.
Again, many thanks for your help