Return sum of the column

[Anonymous]

In the report that I'm working on, I need to calculate a column C which has a minus value for each row. 

Group_tot:=

VAR result1 =  bla bla...
VAR result2 =  bla bla...



VAR Comp = ROUND((result2 - result1 );2)

Return IF(Comp<0;Comp;BLANK()) ( I want to show only minus values)

In report I can see correct results for column C like -1,00 , -0,45 ,... for each row. 

How can I return the sum of the result as well and show it in the bottom of the column C(-1,00 +(-0,45)+...)?

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,
Two measures, only show the second one. 

Single Negative =
VAR _first =
    MAX ( 'Table'[Column1] )
VAR _sec =
    MAX ( 'Table'[Column2] )
VAR _result = _first - _sec
RETURN
    IF ( _result < 0, _result )

Total Negative =
IF ( [Single Negative] < 0, CALCULATE ( SUMX ( 'Table', [Single Negative] ) ) )

 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel