cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jessicarocha
Advocate II
Advocate II

Only show products that were bought by all selected customers

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 

 

filter example.jpg

Thank you in advance!

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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])

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

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?

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!

Power BI Dev Camp Session 22 without aka link and time 768x460.jpg

Check it Out!

Watch Session 22 Ted's Dev Camp along with past sessions!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Kudoed Authors