Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
So, I am really new to power BI. This sounds really simple but I'm clueless how to make it work.
I have two tables, which are linked with a many to many relationship. I want to be able to only show numbers in table A that does not exist in table B.
If we take my example from below i want to be able to show (count: 3) and (numbers: 2, 4 and 6)
Table A
| number | xx | xxx |
| 1 | xx | xxx |
| 2 | xx | xxx |
| 3 | xx | xxx |
| 4 | xx | xxx |
| 5 | xx | xxx |
| 6 | xx | xx |
Table B:
| number | yy | yyy |
| 1 | yy | yyy |
| 3 | yy | yyy |
| 5 | yy | yyy |
Solved! Go to Solution.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |