Forum Discussion
Slicers matching all selection
Hi, I have been trying to crate a slicer in which all condition need to be true. Normally a slicer would use an OR condition in filtering and I need to to use an AND instead. To give you ...
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)
I see. I think this is more of a modelling issue.
What i would suggest you do is,
- Create a new table with all the distinct values from AllProductsOwned Column.
- Create a one to many relationship between the New Products Table and Owned Table.
- Use the new Products column as a slicer and the Owned Table as a filtered table.
I am sure you will get the correct counts.
Many experts suggest not using bi-directional filter except for some rare scenarios.