I want to use StoreName as a filter pane in a comparative analysis. I first have a default state and then broken down to two State1 and State2. The StoreName has to be State1 for example, but it also has to inherit from default state.
Using the logic similar for the measure sum({"State1"<State = $::State>}TOTALSALSAMOUNT), I'd like to apply this state logic on StoreName which will be used in a filter. How do I achieve this?
I've tried something like =Upper($({"State1"<State = $::State>}),STORE_DESC) where it comes out correctly in the expression editor but the on filter pane settings it shows invalid dimension.
