Forum Discussion
Slicers matching all selection
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.
OK, so you are trying to filter 1 side (Accounts) using the column AllProductsOwned(slicer) in the many side (Owned)? Is this correct?
Yes.
The name AllProductsOwned is misleading at it only contains one product per line (it was left from one of my tentatives)