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
Hi @Greg_Deckler I attach an image of the xlsxIn the sheet called Original, 3 cases are shown:
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:
Thank you in advance,Eva
@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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.