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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
afos111
Frequent Visitor

filtering two unlike values

All, im running product on an assembly with numerous steps from application to inspection etc.

 

On step two there is an inspection for certain items and then later down the road at step seven there is an overall inspection.

 

I am trying to filter out the failures at step seven to see who inspected the item at step two.

 

When i try to filter the failure it  will not show the data for the pass at step two becuase no defect happened in that area.

 

Any suggestions ?

afos111_1-1671064727957.png

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@afos111 , Not very clear, but you can use +0 in your measure or try this option to show blank values

 

Show item with No data new.png

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hello amitchandak, im trying to be as descrite as possible without giving any info out. The said items are serialized and have scans in the system at each step. When clicking on the bottom graph "failures" it is filtering out that failure because the top graph is showing the passes in step two. Im trying to filter the serial number to show who inspected that failed serial number at step two.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.