Forum Discussion

Anonymous

Not applicable

7 years ago

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 ...

Anonymous

Not applicable

7 years ago

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.

Anonymous

Not applicable

7 years ago

OK, so you are trying to filter 1 side (Accounts) using the column AllProductsOwned(slicer) in the many side (Owned)? Is this correct?

Anonymous
Not applicable
7 years ago
Yes.

The name AllProductsOwned is misleading at it only contains one product per line (it was left from one of my tentatives)
- Anonymous
  Not applicable
  7 years ago
  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.
- v-piga-msft
  Resident Rockstar
  7 years ago
  Hi Anonymous ,
  
  Have you solved the problem with the suggestion of atif-hafeez ?
  
  If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
  
  If you still need help, please share a simple data sample which could reproduce your scenario so that we could help further on it.
  
  Best Regards,
  
  Cherry

Related content