Forum Discussion
Solved
Slicer with function ANd
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 tim...
Hi,
Please find attached the PBI file.
Hope this helps.
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.
Hi,
Please find attached the PBI file.
Hope this helps.