How to subtract...?

Hello hansreivers 

I hope I have understood your issue correctly. If you want to subtract the yearly values in the "Total" column instead of the default summation, you can use the following measure:

Values = 
VAR _val2024 = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2024 )
VAR _val2023 = CALCULATE ( SUM ( 'Table'[Value] ), 'Table'[Year] = 2023 )
RETURN
    IF ( 
        ISINSCOPE ( 'Table'[Year] ), SUM ( 'Table'[Value] ), 
        _val2024 - _val2023
    )

I have also included a snapshot of the solution here:

If this doesn't solve your issue, please consider providing a sample dataset and a desired solution sample.

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree