Create a measure that hosts matches from two tables

[Syndicate_Admin]

Good, I'm trying to avoid creating a new table by combining queries since I want to create a measure that contains a table where the matches of a column of two different tables are combined. That is, for example, That NewTable = Table1 where the rows of Table1[Col1] match the rows of Table2[Col2].

Could someone tell me how to solve this question?

Thank you!

[PVO3]

I think you need something like:

CALCULATETABLE(

    'Table',

    TREATAS(VALUES('Table (2)'[Column1]),'Table'[Column1])

)

[v-yadongf-msft]

Hi @Syndicate_Admin ,

Can you share with me some screenshots of your data after hiding sensitive information?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang

[Syndicate_Admin]

The two columns marked in those tables share rows with the same information, I want to host those matches to a measure to use as a filter.

Thanks in advance.

Best regards.