How to create a measure to extract common values from 2 columns from 2 tables with no relationship

[MT4U]

Hello,

I have 2 Fact tables Table 1 & Table2 with no relationship to each other.

I need a column which is actually showing the common values of Table1[Column1] & Table2[Column1].

This new derived column can be in another Fact table or Dim table. Can anyone suggest a good method ?

[MT4U]

Hello, Thanks for your reply. I tried a workaround with 'Treatas'.

The logic above will also give results, but if your column is very big means it is taking a reasonably much amount of time to load the visual. But thanks for your suggestion. 🙂

[Padycosmos · Accepted solution]

Please try the following:

Measure = IF(SELECTEDVALUE(Table1[Column1])=SELECTEDVALUE(Table2[Column1]),SELECTEDVALUE(Table1[Column1]))

[MT4U]

Thanks for the reply. But it is not working in my table, maybe due to a huge number of lines of data. Is there any other way to solve it?

[Padycosmos]

Could you paste some sample data here, please?