Filter on a filter?

[breben]

My dataset includes a field with various values, including product name, and another field with customer name.

Each customer name would have multiple product names that could apply to it. 

CustomerA - Acme App, Beta App, Charlie App, Delta App

CustomerB - Beta App, Delta App

Customer C - Acme App, Delta App

Creating visual for this is straight-forward.  My issue is:

I want to have a visual that filters on customers that have Acme App but also shows any other product names that are related to that customer.  A standard/advanced filter can reflect which companies have Acme App, but then I have difficulty getting the other product names to list, since the visual is already filtered to only include the Acme App value.  I've tried this with visual filters and page filters and I always have the issue that once I apply the filter to focus on customers that have Acme App I can't pull in the other product names the customers have since they have been filtered out.  Ideally I would want a filter that decides which customers have Acme App but also still me to list other products the customer owns.  Hopefully this is clear and someone can provide some input. thanks!

[breben]

https://1drv.ms/f/s!Aon5F1BHyS743IsW7AnIX5-M3DRG7g?e=B3VpDo 

this has a sample .pbix.  I'm trying to create a pie chart or similar visual that shows every company that has Acme App and also has App01 or App02 or Beta App or Charlie App, etc.  My list of or's is alot longer in the real-world scenario.  

[Ashish_Mathur]

On double clicking the file, i get a message saying "Unable to open document.  The file sensitivity label could not be verified".

[breben · Accepted solution]

resolved, please try again, thanks!

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached PBI file.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[Anonymous]

Hi @breben ,

Below is my sample table:

I create a slicer using App field:

The final output is shown in the following figure:

If the test sample data I used does not meet your requirements, could you please share the pbix file, thank you!

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.