I didn't check the numbers carefully,
but I think it will work if you adjust your settings on the Dashboard Filter Action
to only have Sheet 4 as a the target.
Please see workbook attached in the Forum Thread.
270593map.twbx 83.7 KB
Hi Carly McCann!
Reply above is accurate - just need to adjust your dashboard filter and you should be all set! To further help and add a signifier to the end user, you could look to add a label once you filter:
IF WINDOW_MAX(COUNTD([State])) = 1 THEN MIN([State])
Best of luck!
Example.twbx 84.4 KB
This worked great, Thank you so much!