Alternate States Issue with Dim filter across states

marcoyukon1 — Wed, 20 Jul 2022 14:27:20 GMT

two states:

State 1
State 2

two measures:

SUM({"State 1"} Price)
SUM({"State 2"} Price)

two dims:

Year
ZipCode

two filter panels: Filter panel 1 only with Year 1 (State 1 ) and Filter panel 2 only with Year 2 (State 2)

ZipCode I need it to be global. but If I apply the filter on Zip Code it won't apply to both measures and it won;t reduce the table rows to only show the zip code selections made on the dim.

There are other "shared dims" that need to be applied to both states at the same time upon selection on a table for price comparison, therefore ading these dims to each state's filter panel for each state will be very impractical.

Table:

ZipCode, Year, Price P1, Price P2

I tried applying to the sheet the state, but it will only one Or the other state.

How do I apply a dim filter that will work across all states ?

Thanks

Re: Alternate States Issue with Dim filter across states

justISO — Mon, 25 Jul 2022 08:23:52 GMT

Hi, make 'ZipCode' filter without states, and modify measures, where states are used, to take 'ZipCode' as 'global':

SUM({"State 1" <ZipCode=$::ZipCode>} Price)

SUM({"State 2" <ZipCode=$::ZipCode>} Price)

topic Alternate States Issue with Dim filter across states in App Development

Alternate States Issue with Dim filter across states

Re: Alternate States Issue with Dim filter across states