Calculated column comparing values between tables with a 1 to many relationship

[czaldumbide]

Hey guys,

I am having trouble creating a calculated column that compares values between two tables with a 1 to many relationship and a filtered date. 

I have an ACCOUNTS table that contains the column Account Number as a unique key. I have another table called DUE-DILIGENCE

that contains the column of Account Number(non-unique) and a Date Column. The relationship between these tables is 1 to many with Account Number as the key. 

Now in my dashboard I have a table that has all Account Numbers as a column as seen below, and I would like to add another column identifying with a yes/no those that are also found in the DUE-DILIGENCE for the specific month and year that the user selects in a slicer. Let me know any suggestions on how I could do this. 

Thanks!

[Greg_Deckler · Accepted solution]

Measure = COUNTROWS(RELATEDTABLE('DUE-DILIGENCE')

Filter on that measure not blank.

[czaldumbide]

Thanks for the solution. I created the measure that you suggested and then used it on a calculated column as follows

DD = if([Measure] = BLANK(), "No", "Yes")