Calculate the outstanding amount receivable from an invoice total

[josimarjr]

Hello,

I need to calculate the balance receivable from the total invoice according to the context of the table below:

The problem is that the invoice amount is repeated across the lines.

It is necessary to calculate in DAX taking into account the invoice number (In the example 165995) the invoice amount (121,558.46) and the sum of the amounts received (75,288.80).

Return = 46,269.66

I manage to get this result, but only when I filter the invoice, when I remove the filter from the invoice, I no longer have the result.

I need to add the receivable amount in both contexts of the attached images.

Considering the invoice amount - total receipts

Thanks

[tamerj1]

Hi @josimarjr 

what should be the expected result of the first context?

What exactly have you tried and exactly was the problem?

[josimarjr]

HI  @tamerj1 

Basically I want to calculate in DAX the amount of the invoice (In the example 165995) and value (121,558.46) minus the sum of the amounts received (75,288.80).

Return = 46,269.66

The big problem is that the invoice amount is repeated because of the number of receipt lines.

Thanks

[tamerj1]

@josimarjr 

Then try to use MAX invoice value instead of SUM