Stock on Hand (Inventory) With Missing Dates for Multiple Sites

[McGran]

I have a stock file that uses [DATE FROM] and [DATE TO] rather than daily snapshots to track the stock position.  I want to report the daily stock position, filling missing dates with the last known position.

This code does exactly what I want in the column, but I'd like the row to also show the sum of stock across sites.

STOCK ON HAND =
CALCULATE (
    SUM ( 'ODS STOCK_LINECODE_DC'[AVAILABLE_STOCK] ),
    LASTNONBLANK (
        FILTER (
            ALLSELECTED ( 'ODS FINANCIAL_CALENDAR'[FINANCIAL_DATE] ),
            'ODS FINANCIAL_CALENDAR'[FINANCIAL_DATE]
                <= MAX ( 'ODS FINANCIAL_CALENDAR'[FINANCIAL_DATE] )
        ),
        CALCULATE ( SUM ( 'ODS STOCK_LINECODE_DC'[AVAILABLE_STOCK] ) )
    )
)

Without measure - Missing dates are returned as blanks and column totals sum stock

	Loc1	Loc2	Total
June	636	4	640
2	321	0	321
3		1	1
4	315	2	317
5		1	1

With Current Measure - Missing dates are now correctly populated and column total shows closing stock position for the period.  However the row totals are not accounting for the newly populated data.

	Loc1	Loc2	Total
June	315	1	1
2	321	0	321
3	321	1	1
4	315	2	317
5	315	1	1

Ideal Measure - Missing dates are still correctly populated and column total shows closing stock position for the period.  Row totals are account for the newly populated data.

	Loc1	Loc2	Total
June	315	1	316
2	321	0	321
3	321	1	322
4	315	2	317
5	315	1	316

Is this possible?