Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

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. 

  • Anonymous,

     

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

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

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support

    Anonymous,

     

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

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