Join 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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello Community
I am trying to subtract the "No" column (Table 2) from to "No" column (Table 1) and want to display the result by the "Name" column.
I have tried using UNION and SUMMARIZEDCOLUMNS, but it is not showing me the correct result.
Can someone help me?
| Table 1 | |
| Name | No |
| A | 1 |
| A | 2 |
| B | 3 |
| B | 1 |
| C | 2 |
| C | 3 |
| Table 2 | |
| Name | No |
| A | 2 |
| B | 3 |
| C | 4 |
| A | 4 |
| A | 2 |
| A | 2 |
| Expected Result | |
| Name | No |
| A | 7 |
| B | -1 |
| C | -1 |
Solved! Go to Solution.
Expanded table, bridge table or disconnected table are all methods to tackle such a simple question.
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Expanded table, bridge table or disconnected table are all methods to tackle such a simple question.
| Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!