Happy New Year to you too. I think I’ve come up with a neat solution on this one for you.
Check it out in the service first, since you don’t have to worry about click versus ctrl-click there. Just make a selection(s) in the Franchise slicer and click the adjacent button, which should route you to the correct visual or direct you to select a different combination.
The way I have done this is to create a disconnected Franchise table with the slicer selections in it. Then created the adjacent button next to the slicer, tied to a conditional page navigation action invoking this measure:
Route Page =
VAR Selections =
VALUES( Franchise[Selection] )
VAR Page =
AND( COUNTROWS( Selections ) = 1, "AWM" IN Selections ), "AWM",
"AWM" IN Selections, "Other",
which routes to the proper page based on the SWITCH/TRUE statement logic within the measure derived from your requirements. Copied this slicer/button combo to all three pages and synced the slicers so that regardless of which page you ended up on it would reflect the choices made prior to hitting the button.
I hope this is helpful and meets your requirement. Full solution file attached below.
eDNA Forum - Dynamic Measure Change Scenario Solution.pbix (1.6 MB)
PS – once I saw the complexity of the slicer logic, I decided to abandon the calculation groups idea.