Forum Discussion

hansreivers's avatar
hansreivers
Icon for Helper I rankHelper I
1 year ago
Solved

How to subtract...?

Hi all,   I need help. These are some random figures from 2024 and 2023. Where you see the Total, you see the summarized values of 2024 + 2023. I need to subtract them in the total. Is this possibl...
DAX
Help
Need Help
subtract filtered value
subtraction of Row
  • quantumudit's avatar
    quantumudit
    1 year ago

    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

dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

Hello hansreivers , 

 

At the total level you need to change the logic, please try the below measure..

 

AdjustedTotalMeasure =
IF(
NOT(ISINSCOPE('Table'[Year])), -- Checks if the calculation is in the total row
SUM('Table'[2024_Column]) - SUM('Table'[2023_Column]), -- Calculation for the total row
SUM('Table'[2024_Column]) + SUM('Table'[2023_Column]) -- Regular sum for individual years)

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

 

Thank You

Dharmendar S

LinkedIN