INTERSECT with tables having different amount of columns

[Pbiuserr]

Hello, 
I have two tables - dimension and fact. Dim has 10 columns, Fact 28

All I want is to INTERSECT their id's. How can I do that? Tried with FIRSTNONBLANK, VALUES, DISTINCT I keep having " A table of multiple values was supplied where a single value was expected" 

How to handle that?

[FreemanZ · Accepted solution]

hi @Pbiuserr 

INTERSECT returns a table, if you are creating a measure try like:

Measure = COUNTROWS(INTERSECT())

or

Measure =

CONCATENATEX(

   INTERSECT(),

   DimTable([ID]),

   ", "

)

[Pbiuserr]

I still got output that "Each table argument of 'INTERSECT' must have the same number of columns.". Can you help me on that?