How to calculate difference between two rows in a table?

[Anonymous]

Hi everyone,

I need your help. I want to calculate the difference of Montant of C and D. Supposingly, I would like to subtract montant of C from montant of D. I want to display Difference i.e- 0.10  instead of total value displayed in third row. 

Thanks in advance. 

Best Regards,

Diksha Gupta

[FrankAT]

Hi @Anonymous ,

Your two numbers exceed the computational accuracy of Power BI Desktop. I have therefore shortened it a little and added a calculated column for calculation.

Subtract = 
IF (
    HASONEVALUE ( 'Table'[Sens Montant] ),
    MIN ( 'Table'[Value] ),
    SUMX ( 'Table', 'Table'[Value] * 'Table'[Value Type] )
)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[Anonymous]

Hi Frank,

Thank you for replying. How did you calculate value type column? Could you pls tell it?

Regards

[selimovd · Accepted solution]

Hey @Anonymous ,

you can subtract one from the other:

Difference Montant C to D =
CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "D"
)
- CALCULATE(
    SUM( myTable[Montant] ),
    myTable[Sens] = "C"
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hey It worked but why is It 0.13 instead of 0.10?

Thank you

[Anonymous]

Hi , Thank you for replying.

The formula suggested by you is not working fine. Could you please suggest something else instead?