Report Filter Context Issue

[Anonymous]

I hope someone can help. I have table of invoice records. I want to create measurement that will calculate the total Shipping Amount for the most recent invoice. The below measurement works as expect however the calculation only applies if the most recent invoice date is included in the report filter. For example, my current results shows the following. How do I get the $1000 value to appear on both records?

    Customer         Invoice Date  ShippingCharge_Current

               XYZ              11/11/21                    blank

                                    11/12/21                   $1000

ShippingCharge_Current =

Var LastInvoiceDate = CALCULATE(MAX('Invoice'[InvoiceDate]),ALLEXCEPT(‘Invoice’ )[Customer]),ALL(Calendar), ‘Invoice'[Shipping]<0

Var LastInvoiceNum= CALCULATE(Max('Invoice'[Invoice Number]),AllExcept('Invoice',[Customer]),ALL(Calendar),'Invoice'[InvoiceDate] =LastInvoice)

Return CALCULATE('Invoice'[Shipping_Measurement],ALL(Calendar),AllExcept('Invoice',[Customer]),FILTER('Invoice','Invoice'[InvoiceNumber]= LastInvoiceNum))

[amitchandak]

@Anonymous , Try like

calculate(lastnonblankvalue(Invoice[Invoice Date], sum(Invoice[Shipping_Measurement])), allexpect(Invoice, Invoice[Customer]))

[Anonymous]

The suggestion did not work. I need the current shipping charge to appear on all invoice records. 

[Anonymous]

How do I incorporate this in my current code?

[amitchandak]

@Anonymous , as a new measure

[Anonymous]

Can you provide more direction. I need a single value measurement. Not a table.

Thanks