topic Filter Tickets where at least one line item contains a particular product in DAX Commands and Tips

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

eomedes — Thu, 13 Apr 2023 15:59:42 GMT

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-p/740516

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

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

Greg_Deckler — Thu, 13 Apr 2023 16:26:22 GMT

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.

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

eomedes — Fri, 14 Apr 2023 06:56:24 GMT

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