Filter by a value to see all related instances

[Liam01]

Hello,

We have Order numbers that relate to Products - sometimes the Order may have more than one Product against them. I'd like to be able to filter by the Product and return all instances of the Orders that contain it. I've done the table below as an example: 

So in this instance, I want to see all the Orders that have AB as the Product but also any other products that may be against that Order.

Left is how my data looks and the right is after filtering

Order	Product		Order	Product
12345	AB		12345	AB
12345	YZ		12345	YZ
23456	OP		34567	MN
34567	MN		34567	AB
34567	AB		67890	AB
45678	FG
56789	KL
67890	AB

Hopefully that makes sense - not sure if this is easy and i'm being stupid!

Thanks

[amitchandak]

@Liam01 , Plot a measure like belwo with order number

calculate(Count(Table[Order]), filter(Table, Table[Product] = "AB"))

[Liam01]

Hello,

Thanks but that only shows a count where the Product = "AB".

I want to see all the instances of the Orders whereby at least one of the Products is "AB" so as the table I posted shows on the right, it would show any Orders with a single AB and also show any where there's an AB and another different Product, not only show the count.

Thanks