GRAND TOTAL FALSE

Hi community,

Last value by Year =
VAR LY =
    CALCULATE (
        LASTNONBLANK ( 'Calendar Table'[Date], [Sum Valorisation] ),
        FILTER (
            ALL ( 'Calendar Table' ),
            'Calendar Table'[Date] <= MAX ( 'Calendar Table'[Date] )
        )
    )
RETURN
    CALCULATE (
        [Sum Valorisation],
        FILTER ( ALL ( 'Calendar Table' ), 'Calendar Table'[Date] = LY )
    )

With this solution i get the last known value for each line, each year

Is it possible to obtain the grand total of the retained values ​​per year?

As you can see below when I select more than one asset, last value per line work's fine but the grand total is false. I need it for calculating portfolio ratios.

Thanks you