Only show products that were bought by all selected customers

[jessicarocha]

Hi everyone, 

I would like to create a filter that gives the option for the user to only see the products in common by all the selected customers. So, to see which products were bought by ALL the selected customers.

For my analysis it is interesting to see the ABC table. However, if it is better to do a formula with a numeric metric, it is possible to use quantity because when there is no quantity sold, there is no ABC classification for us.

Is it possible to achieve this?

Below is the link of the dummy file for download:

Dummy file 

 

Thank you in advance!

 

[amitchandak · Accepted solution]

@jessicarocha , Product Having all customers

measure =
var _cnt = calculate(distinctcount(Sales[Customer ID]), allselected(Sales))
return
countx(filter(Summarize(Sales, Product[Product ID], "_1", distinctcount(Sales[Customer ID])), [_1] =_cnt), [Product ID])

[jessicarocha]

Hi @amitchandak ,

Thank you so much! This is what I need. Just another thing: is it possible to put this as a filter in a slicer and not only as a filter in each individual table?
so can be iteractive for the user?