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 ) )
Check out the changes to the Power BI Community announced at Build.
Find out more about the May 2023 update.
Visit our Data Stories Gallery and give kudos to your favorite Data Stories.