SELECT() in a formula on a Virutal column is not returning any rows

[Shyam1]

My App has two tables

MemberDetails table has Site No, Name,Phone etc

Trx Register table has Site NO,Item, Payment mode, Payment Amount,Payment Status

Have added a Virtual Column - Pending Member Dues on Memberdetails table and set formula to select all the pending dues from trx register for given Site number. 

SELECT(Transaction register[Item],([Site Number]=ANY(Transaction register[Site No])),true)

But the Virutal column(Pending Member Dues)

is coming blank.. ANy pointers to fix the issue?

[TeeSee1 · Accepted solution]

I believe it should be something like this ...

SUM(
  SELECT( Transaction register[Payment Amount],
    AND(
      [Site No]=[_THISROW].[Site No],
      [Payment Status]="Pending"
   )
  )
)

[Shyam1]

Thanks for your inputs, will try the solution and confirm

[Shyam1]

thank you @TeeSee1 , your solution worked thanks