Trying to understand this a little better...
Can users access that dashboard directly (without getting there via a hyperlink action?)
And are you only going to pass one single state value in the URL?
You could have an extra parameter that indicates whether the entry to the dashboard was done via a URL. And you could pass the state value as a parameter rather than a filter.
Then, when the upper target sheet opens, you could have a calc filter that looks at the parameter indicating that it was invoked via URL. If that's turned on, then don't filter at all. But in the second sheet have a filter that says, [State] = [State Parameter] and filter that sheet.
I converted Target to 10.5 because that's what our server is.
Look at the URL string in LandingPage. I pass <state> to the parameter that I created in the Target workbook.
In Target I took the [State] filters off both sheets. There was also an action filter that grabbed a Texas zip code. I took that off too. I'm not sure where it came from, but if it's important you can put it back in there.
So I created a calc on the Ranking sheet to use [StateParam] to filter the sheet. And since no State filter is on the Overall sheet, you get all the regions.
I created a [FromURL] parameter in both workbooks. I'm not passing it yet, but if there are circumstances where you do NOT want filtering in the Target workbook, let that parameter control it. Publish target with that param set to "N". If users bring up the workbook on their own rather than via the URL action, then the param being published with "N" as the default lets your calc know that they aren't access the sheet voa the URL action. But on the URL like, add another parameter to the URL string.
Right now it looks like this:
Change it to this:
You can have as many params and/or filters as you need in the string.