Forum Discussion
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-msftCommunity 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 )