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 t...
Need Help
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

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

    Measure =
IF ( SELECTEDVALUE ( Table2[ColumnB] ) = SUM ( Table1[ColumnB] ), 1, 0 )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

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

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