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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Liam01
Helper I
Helper I

Filter by a value to see all related instances

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

 

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

 

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

 

Thanks

2 REPLIES 2
amitchandak
Super User
Super User

@Liam01 , Plot a measure like belwo with order number

 

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

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.