I have two tables where there is a many to many relationship.
I want to see where the IDs match and are also occurring more than once:
Table 1: Table 2: Output Table
ID ID ID
12 10 14
Many thanks for looking!
Go to Solution.
Many thanks for that!
It's put me on the right track.
View solution in original post
Output Table =VAR T1 =FILTER ('Table 1',COUNTROWS (CALCULATETABLE ( 'Table 1', ALLEXCEPT ( 'Table 1', 'Table 1'[ID] ) )) > 1)VAR T2 =FILTER ('Table 2',COUNTROWS (CALCULATETABLE ( 'Table 2', ALLEXCEPT ( 'Table 2', 'Table 2'[ID] ) )) > 1)RETURNDISTINCT ( INTERSECT ( T1, T2 ) )
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.