Subtract values from 2 columns based on a related column

[Anonymous]

Hi,

I have 2 tables, Clean Data, and Deposit details.

I have made a relation with the File ref Column, and matched the Liability per GL (from the Deposit details table), and the Amount column ( from the Clean Data)

I want to make a measured column which give me the sum, so that I can make sure that there are no file refs that have over or under balances.

Not sure if a measured column is the correct way to go about this problem.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

You want to create three measures.  Rather than just pulling [Liability per GL] and [Amount] directly from the tables you write a measure to sum them so you can use them in other measures.

Total Liability = SUM ( 'Deposit Details'[Liability per GL] )

Total Amount = SUM ( 'Clean Data'[Amount] )

Then your compare measure looks like this

Remainder = [Total Liability] + [Total Amount]

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.