GRAND TOTAL FALSE

[nasolme]

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

[V-lianl-msft · Accepted solution]

Hi @nasolme ,

Please try to use SUMX function:

Measure = SUMX(VALUES('TABLE'[YEAR]),[Last value by year])

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.