Forum Discussion

fz1's avatar
fz1
Frequent Visitor
3 years ago

Find common values based on selected category

I am very new to PowerBI and am trying to dynamically find the common values in one column based on selected category(ies) in another column. For example, I would like to know from the following table what are the common Items based on the Store column:

Such that, if I have a slicer with the Store names and select all stores, I'll get the following results:

Or if I select Stores A and B on the slicer, the table will update to this:

 

Thank you very much!

 

Need Help

3 Replies

    • fz1's avatar
      fz1
      Frequent Visitor
      3 years ago

      thank you so much for the response, but I believe what I'm trying to do is a little different than what the video is showing as my data is structured differently. The video shows the first two records have the same combination of "Work Order" and "Responsible" (1234567 and Dan) - my dataset is different in that each combination of "Work Order" and "Responsible" is unique. So, to go back to my requirement: I am trying to find what Items are common in the Stores; to give another example, if I select stores B and C, it will show only the common items in both stores (=bread and cheese).

      To give a little more context, all my data is currently in one table (so I wouldn't need to link any tables) and I am using one of the columns as a slicer (in the above example, it is the Store column). Also, the real dataset I am using has about 10k records.

      In summary, I am trying to make multiple selections on the slicer and have it return the intersecting records on my table based on the slicer as opposed to returning all the records (which is what it is currently doing).