Need to find total value from ref table using SUM()

[Badminton_Scori]

Hi ,

I am trying to calculate the total value of the ref table by using the below formula

SUM(SELECT(Bills[Line value],AND([Customer Name]=[ID],[Status]=“Credit”)))

I am using the above formula in the parent table in virtual column but I am not getting the total value .

I need to total value ,where the status is credit ,Please help me with the expression