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

quantumudit's avatar
quantumudit
Icon for Super User rankSuper User
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

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

Hi both, thanks for your replies. I tried the solution of quantumudit and this works when I use the SUM of the turnover, but is this also possible when I use a measure? 

 

My measure is;

Turnover = CALCULATE (SUM( table[turnover])