How To Cross Reference Between Two Tables

[cmcgo3]

*** Any assistance would be greatly appreciated !! ***

I have two tables; Scores and Sample Table, one (Scores) containing a list of 200 names.  The other table (Sample Table) is a copy of first table with a sample function that will generate a random 25 names by week.  I am trying to create either a calculated column or DAX in the first table that will tell me which names in the second table have been sampled.  I am thinking that my difficulty lies in the fact that the second table is a copy of the first..

Since Mitchell Chapman is in the Sample Data I would like it to say "true" or "1" in the All Data

Sample Table =

VAR ProductNum_=

DISTINCTCOUNT('Scores'[name])

return

SAMPLE(ProductNum_ *25,'Scores',[name])

test.pbix 

[Anonymous]

Hi @cmcgo3 ,

Please try code as below to create a measure.

m1 =
IF ( MAX ( 'All DATA'[name] ) IN VALUES ( 'SAMPLE DATA'[name] ), 1, 0 )

Best Regards,
Rico Zhou

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

[cmcgo3]

Thank you, will give it a try