Display the same calculated amount for each line within the same invoice in a table

[EZV12]

Hello all,

I need help for a formula within a table. 

This table is called "FactInvoicePayment", there are many invoices inside and each invoice has many invoice lines.  I have the amount of each invoice line, but the payment is a total amount for the invoice. Now I need to deduct the amount of special invoice line marked as "S" under the column "InvLine Type" from the total payment, and the calculated amount should be displayed beside each invoice line under the same invoice.

Thanks in advance.

[amitchandak]

@EZV12 , You can get invoice amount on each line like

new column = sumx(filter(Table, [Invoice] = earlier([Invoice]) ), Table[Amount] )

measure

measure = sumx(filter(allselected(Table), [Invoice] = max([Invoice]) ), Table[Amount] )

or

measure = sumx(filter(all(Table), [Invoice] = max([Invoice]) ), Table[Amount] )

or

measure = sumx(filter(all(Table [Invoice]), [Invoice] = max([Invoice]) ), Table[Amount] )

[EZV12]

Thank you for your reply, however, it doesn't work.

What I need is to deduct the amount of special invoice line marked as "S" under the column "InvLine Type" from the total payment (column "Payment", same amount for each invoice line under the same invoice), and the calculated amount should be displayed beside each invoice line under the same invoice.

May you please advise? Thanks

Thanks in advance.