Filter sales tickets which contain specific item & show all items on the ticket

[Ivan_C]

Hi all,

I have a long list of sales tickets with multiple items and their turnover and quantities on each ticket.

I'm looking for a way to filter and display all tickets which contain a specific item but  I want to show all items on these tickets, not only the specific item.

Unfortunately I can't share any of the data on this forum. Any help in the right direction would be greatly appreciated!

The fields are:

DateTime

TicketID

ItemID

ItemDescription

ItemTurnover

ItemQTY

Thanks,

I

[Ivan_C · Accepted solution]

Update

I found the solution in another post:

https://community.powerbi.com/t5/Desktop/Filter-Invoices-where-at-least-one-line-item-contains-a/td-...