Slicer with function ANd

[Priem_fut_ael]

If multi selected in slicker Shop_1 and Shop_2, in table visualisation displayed all products from this shops. 

How to display only those products that are available in two stores at the same time? Need method with using slicker.

[Priem_fut_ael]

Ashish_Mathur, this works great, thank you so much! 🙂 

[Ashish_Mathur]

You are welcome.

[Priem_fut_ael]

Please help me! I think the solution to the problem should be simple. Once again, the result of the selection on the slicer should be only products that are available simultaneously in all selected stores.

It looks like inner join in sql, but in my case there is only one table.

[Priem_fut_ael]

Thanks, good article, but it doesn't fit.

I have 1 table and 1 slicer. 

Data in my Table:

Products;Shops

Product1;Shop1

Product2;Shop2

Product3;Shop3

Product1;Shop2

If selected Shop1 and Shop2 in slicer, result data in visual table:

Product1;Shop1

Product2;Shop2

Product1;Shop2

But I need to get the result:

Product1;Shop1

Product1;Shop2

Perhaps I missed something?  I understand that I have to use dax and use measure to filter the table. Please help me. 

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[vicky_]

Checkout this blogpost for implementing an OR slicer: https://apexinsights.net/blog/or-xor-slicing