Forum Discussion
Slicers matching all selection
Are you sure about your statement? If you select product1 and then ctrl-select product2, you should see results for both product1 and product2
Sorry I might not have explained myself properly.
Yes if I ctrl-select the two products it shows both of them but works with a logic of either-or.
To give you an example If I select Prod1 alone it gives me 10137 records, Prod2 alone gives 381 records. Selecting both the records are 10313 as some records bought both Prod1 and Prod2. What I would like the slicer to do is to show me the 205 records owning both Prod1 and Prod2.
Is there any way to do so?
Can you provide details about the schema of the filtered table and its relation with the slicer?
This is the current schema. The table Owned has one line per account per product and it filters the Accounts one having one line per account.