Filter Tickets where at least one line item contains a particular product

[eomedes]

Hello community,

I have a single table in my model with 2 columns, CODE and ID_TICKET.

The following image shows 2 tables:

- The one on the left has the CODE column and a count of ID_TICKET.

- The one on the right has the ID_TICKET and the CODEs that make up that ticket.

I have used this link, https://community.powerbi.com/t5/Desktop/Filter-Invoices-where-at-least-one-line-item-contains-a/td-...

It is similar but I need that when I click on the yellow CODE in the left table, the right table shows the 3 tickets in green, but with the rest of the CODES that compose the ticket.

Right now, if I click on the yellow code in the first table, the second table shows the following:

But what I want is:

Can anybody helpme? Thank you very much in advance.
Eva
@PowPow @PowBi @bradmi @admi 

[eomedes]

Hi @Greg_Deckler 
I attach an image of the xlsx
In the sheet called Original, 3 cases are shown:

• What is initially there;
• What I have now;
• What I want.

In the DB sheet is the table to test with.

I don't think your example of the complex selector is valid, because I don't use maximums, sums... all I have and want are texts.

1. ORIGINALS:

2. ORIGINAL:

3. ORIGINAL:

1. DB:

Thank you in advance,
Eva

[Greg_Deckler]

@eomedes You need a Complex Selector. The Complex Selector - Microsoft Power BI Community If you can post sample data as text can be more specific.