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
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:
e.g.
Table 1: Table 2: Output Table
ID ID ID
12 10 14
14 14
14 14
14 15
15
15
Many thanks for looking!
Solved! Go to Solution.
Many thanks for that!
It's put me on the right track.
Hi @laganlee
please try
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
)
RETURN
DISTINCT ( INTERSECT ( T1, T2 ) )
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |