Family Household Completion

[ataft3]

I am sure this must be straightforward, but I'm struggling today!

I have two tables, one with parent data pertaining to completing a form, and one with their children. I need to quickly identify for every child if at least one parent completed the form and similarly, a child with no parent completing the form. My data is set into two tables as follows:

Parent

Status	User Id	First Name	Last Name	User ID1
Not Started	123456	Kevin	Smith	1
Submitted	654321	Cynthia	Lee	1

and Students

User ID1	First Name1	Last Name1	Grad Year
1	Catherine	Smith	2021

[ataft3 · Accepted solution]

I had a moment of insight (which was sorely lacking yesterday): I transformed the text data into 1 for complete, 0 for incomplete, converted to a number (an easy oversight, as the transform, doesn't change the type), and created the following calculated column in the student table:

Column = CALCULATE(SUM(panrets[Status]))