Filter contains - If this item number is present on order show whole order.

[Rygaard]

I need to see all orders where one or more lines have a certain item number

(so I want to see everything the customors who bought redshirts have bought)

now i could filter for that item number but then i cannot see all the other items on that order.

Filter : item no =123

Order	item	show line ?
1	123	yes
1	456	yes
1	466	yes
2	789	No
2	456	No
2	466	No
3	123	yes
3	123	yes
3	123	yes

So bassicly if item numer 123 has EVER been used on this order (within the other filter, date, department and so on I have on) I want to See ALL lines that match other filters.

Im lost - I could hardcode this on the table, but "123" needs to be a selectable value, next week we want to look at 398... and so on...

[v-yalanwu-msft · Accepted solution]

Hi, @Rygaard ;

You could create a table as a slicer .then create a flag measure apply it into filter.

1. create a table.

slicer = VALUES('Table'[item])

2.create a flag measure.

flag = 
var _sel=SUMMARIZE(FILTER(ALL('Table'),[item] in ALLSELECTED('slicer'[item])),[Order])
return IF(MAX('Table'[Order]) in _sel,1,0)

3.apply it into filter.

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daryl-Lynch-Bzy]

Hi @Rygaard 
I think you might interested in understanding single or multiple values from a Slicer selection can be used to impact measure.  Please considering watching the following Curbal video to see if this helps.  DAX Fridays! #118: Get selected or multiple values from slicers using DAX - YouTube