Forum Discussion

cmcgo3's avatar
cmcgo3
Helper II
2 years ago

How To Cross Reference Between Two Tables

*** 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 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.