Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
eomedes
Regular Visitor

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

Hello community,

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

The following image shows 2 tables:

eomedes_1-1681401319146.png

 

- 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:

eomedes_2-1681401415574.png

 

But what I want is:

eomedes_3-1681401459259.png

 

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

2 REPLIES 2
eomedes
Regular Visitor

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:

eomedes_0-1681455047334.png

 

2. ORIGINAL:

eomedes_1-1681455065970.png



3. ORIGINAL:

eomedes_2-1681455083357.png




1. DB:

eomedes_3-1681455102218.png

Thank you in advance,
Eva

 



Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors