I need to compare two columns (Not a measure) of different tables.

[rishari]

DAX:

DAX_name = IF( Table1[Column1] = Table2[Column1], [DAX_Measure], 0)

I'm not able to achieve it. I'm new to DAX.

Could anyone help me on this.

[amitchandak]

@rishari , You can not simply use other tables column

If this from one side on the tables

DAX_name = IF( Table1[Column1] = related(Table2[Column1]), [DAX_Measure], 0)

from many side of the table

DAX_name = IF( Table1[Column1] = maxx(relatedtable(Table2),[Column1]), [DAX_Measure], 0)

Custom relationship

DAX_name = IF( Table1[Column1] = maxx(filter(Table2, Table1[ID] = Table2[ID]),[Column1]), [DAX_Measure], 0)

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[rishari]

After IF, I can get only the Measures but not the column names.