Suppose I have a dashboard showing the available products of my stores. I have a filter of the stores on top that is a Dropdown list. If I filter two stores, for example Store A and Store B, it shows the products that are either on Store A OR Store B. Is there a way to filter so it shows products that are both on Store A AND Store B? Without having to create a new column/filter with all possible combinations?
Hello @ramoshe05
If I understand correctly, you want the product filter to show all products that are related to both Store A and Store B when you select them in another filter. If that’s the case, you could use the Control Options > Change Relevant Values on the product filter to relate it to the store filter. I hope this helps you!
I’ll explain better: The filter shows products either on Store A or Store B. Is there a way to filter that shows products that are both on Store A and Store B? (In this example it would only show Product X & Product Y, NOT product Z)
I was thinking whether Nested filter can help and tried to test in my end
There are 4 use cases described in this blog about market basket analysis but they are a bit different with the cases you mentioned. Seems not able to help your case
Another approach is using custom SQL with dataset parameters. So that you can include some complex query logic. When user changes the parameter in the dashboards, it passes the parameter to the data source.
Some consideration is… the data source needs to support Direct Query
Hi @ramoshe05,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Brett & @royyung since the dataset doesn’t support Direct Query the only idea that I have is create a filter with all possible combinations which is not ideal 
If someone has another idea please share!
Isabella
Hi @ramoshe05 - try this out. There are some considerations outlined in the text box in there. Overall concept uses binary math to do the ‘market basket / AND’ type of analysis.
If you have never used Arena before, watch the tutorial, and then you can create a copy of the analysis to see how it was built.
AND market basket
Quick note, I used the sample data you provided and in one of your message you said expected result should show products X and Y but should be Y and Z based on that data.
I added one more sheet which uses a single control that I think should work too but you would need to test it on a larger dataset with more stores.
@Jesse & QuickSight team Thank you so much for creating the Arena, the solution works for my use case. 