need help with a distinct union type measure

[sedric1]

I have two tables; one is a summarized table called "Enrollment Summary" that contains a "User ID" column and an "Enrolled" column with Yes/No answers. 

Then I have a second summarized table called "Missing Enrollments" which also has a User ID column.

I am trying to get the full listing or count of distinct User Ids on both tables. The only caveat is that on the "Enrollment Summary" table, I want to filter those user IDs to only union where enrolled = No. All help is appreciated!

Enrollment Summary			Missing Enrollments
User ID	Enrolled		User ID
User A	Yes		User B
User b	No		User D
User C	Yes
User B	No
User A	Yes
		Expected Result:	Count = 2
		User ID
		User B
		User D

[amitchandak · Accepted solution]

@sedric1 , This table will give all those users

distinct(union(summarize(filter(Enrollment, [Enrolled] ="No"),[User ID]),all(Missing[User])))