Total column to clustered chart

Hi MaxSchrijen23 ,

I think you are going to add a total column to the clustered column chart.

Here's my solution.

Sample data

1.Create a table as follows(Enter data). If you have a lot of values and it is not convenient to enter them directly, please let me know.

There's no relationship.

2.Create a measure.

Measure =
IF (
    MAX ( 'Table (2)'[ID] ) = "Total",
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Year] = MAX ( 'Table'[Year] ) )
    ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', [ID] = MAX ( 'Table (2)'[ID] ) )
    )
)

3.Results.

Best Regards,

Stephen Tao

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