Comparing columns from diff tables in a table visualization that are related by diff columns

[Anonymous]

Hi,

Super new to Power BI. I have related two tables (Table1 and Table2) by a pair of columns with a many to one relationship (Table1[ColumnA] and Table2[ColumnA]). I then created a table visual to display both Table1 and Table2 data now paired by the ColumnA relationship. How do I create a column that compares other columns in the newly created data visual table related by ColumnA. ie Table1[ColumnB] to Table2[ColumnB] in the table visual that returns 1 if they are equal and 0 if they are not equal? 

Please let me know if this explanation makes sense and I'll try to clarify. 

[v-chuncz-msft · Accepted solution]

@Anonymous,

Drag Table2[ColumnA], Table2[ColumnB], Table1[ColumnB] and measure below to Table visual.

Measure =
IF ( SELECTEDVALUE ( Table2[ColumnB] ) = SUM ( Table1[ColumnB] ), 1, 0 )