How to create past due values

Hi NDG 

It is a Pivot table. You can use Matrix visual to achieve a similar result. But can you provide some dummy data to show the table structure of original data? And how many tables are used in this model? At least we need to know which columns are from which tables and what relationships are between them. 

For example, if Scheduled Ship Date and Actual Ship Date are from the same table, you can try below measure. But it is based on my assumptions and it doesn't consider Credited Plants. Without data, it's difficult to write a DAX formula which is appropriate to a model. 

Past Due Total =
CALCULATE (
    SUM ( 'Table'[$ value] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Scheduled Ship Date] < 'Table'[Actual Ship Date]
            || (
                ISBLANK ( 'Table'[Actual Ship Date] )
                    && MAX ( 'Date'[Date] ) > 'Table'[Scheduled Ship Date]
            )
    )
)

Regards,

Jing