Forum Discussion

Lolita's avatar
Lolita
Regular Visitor
6 years ago

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 req...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

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,

Amy 

 

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.

Lolita's avatar
Lolita
Regular Visitor
6 years ago

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! 

v-xicai