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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.