Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Data completetion vs required

Hi There,

Hope all is well during these times & thank you in advance for your help 🙂


I have a simple model, one table with Item_Numbers that have test requirements in columns. if "0" is not required, if "1" it is required.

I also have a table with the serial numbers associated with those item_numberst that are ready for shipment. I need to make sure each of those serial numbers were fully tested and passed the test. See my model below.

My return would be: what are those serial numbers that don't meet that criteria.







Community Support
Community Support

Hi @Lolita ,


You may put the Table2[serial numbers] and Table1[test requirements column] into the same Table visual, and set filter Table1[test requirements column] =0 in visual level filter pane.


Or could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.


Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.


Best Regards,



Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regular Visitor

Hi Amy,


I might have not been clear on my request (sorry, english is not my primary language)


I’d like to have (preferably through a column or measure) to output

  • Serial Numbers that are missing a test requirement
  • Or that a required test doesn’t have at least one record of “0” for pass

Thank you again! 


Regular Visitor




Thank you so much for your response! 


Please see attached for link on the sample data I prepared... 🙂 


With your suggestion below, I think it would return all the requirements for the serial numbers that are ready to ship... but How can I make sure that all of them were met? 

Super User IV
Super User IV

Please see this post regarding How to Get Your Question Answered Quickly:


Sample data as text, expected output


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors