Calculating Total Balance Per Customer For Individual Transactions

[ksanderson]

I am attempting to calculate a running total of all the transactions that match the criteria of the tenant and property column. 

Here is table 1 - the transactions. 

I am looking to calculate in the Contract rental amount collected column ,in table 2, the running total of any transaction that has matching REF columns Tenant & Property. 

Table 2 - total 

I tried this formula to do it based on tenants REF alone, but, it did not calculate anything. 

If anyone can help me I would be greatly appreciative 

[TeeSee1]

You can try

SUM(
 SELECT(
  table 1[Rentatl Collection Amount],
  AND(
   [Property] = [_THISROW].[PROPERTY],
   [Tenant] = [_THISROW].[TENANT]
  )
 )
)