Dynamic column values based on second table

[Anonymous]

Hi All,

I need some info where I have 2 tables without the relationship, I need to find SID value from another table if both matches Yes nor no. 

what are the options in the direct query to handle this issue    

Column1Column2

Table 1
	ID	SID
	1	7683739
	2	8790111
	3	7683739
Table 2	Column1
	SID
	7683739
	7649463
	7683739

Thank you

NG

[v-yuta-msft · Accepted solution]

@Anonymous,

Create a measure in Table 1 using DAX below:

Measure = CALCULATE(MAX('Table 1'[SID]), FILTER('Table 1', 'Table 1'[SID] in VALUES('Table 2'[SID])))

 

Community Support Team _ Jimmy Tao

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