Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Drag Table2[ColumnA], Table2[ColumnB], Table1[ColumnB] and measure below to Table visual.
Measure = IF ( SELECTEDVALUE ( Table2[ColumnB] ) = SUM ( Table1[ColumnB] ), 1, 0 )
Drag Table2[ColumnA], Table2[ColumnB], Table1[ColumnB] and measure below to Table visual.
Measure = IF ( SELECTEDVALUE ( Table2[ColumnB] ) = SUM ( Table1[ColumnB] ), 1, 0 )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |