Multi-Conditional Lookups

Since you have robust line-by-line data, you might be able to try a measures like this:

Zone= CALCULATE('Table'[Zone], FILTER(ALL([Transaction Date]) ,  MAX([Transaction Date])))

Weight= CALCULATE('Table'[Weight], FILTER(ALL([Transaction Date]) ,  MAX([Transaction Date])))

If you drag these onto your table is should do this for each tracking number.

Sorry I just saw that it needs to not be blank as well. Try creating this measure:

Zone = 
// Create Table Filtered by blanks
VAR __table1 = FILTER('Your Table',[Zone]<>Blank())
// Create a table that just holds the record we want
VAR _table2 = FILTER(_table1,max('Transaction Date/Time'))
//Get the zone
VAR _zone= calculatetable(_table2,max([Zone])
return
_zone

You should be able to do the sasme with weight, just replace the [Zone] with [Weight] and rename _zone to _weight.