Use of if in dax for different tables

[nicolasvc]

I have two tables, the first table A has an id with the supply and demand, and from that I have another table B and in that I have to put the sum of the subtraction between demand - supply for each ID, as shown. I know how to create a column from two others, but it makes it difficult for me to use it for each ID.

A

ID	demand	supply
1	1000	800
1	700	500
2	100	100
3	800	500

B

ID	TOTAL
1	400
2	0
3	300

[parry2k]

Oops, sorry about that. Thanks for pointing out. 

[v-angzheng-msft]

Hi, @nicolasvc , 

@parry2k , there is an extra equal sign in the measure above😁

Total = SUM ( Table[Demand] ) - SUM ( Table[Supply] )

[parry2k]

@nicolasvc why you need another table, you can create a table visual, put ID and the following measure on it:

Total = SUM ( Table[Demand] ) = SUM ( Table[Supply] )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡