cancel
Showing results for
Did you mean:
Highlighted
Helper II

## Return sum of the column

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)+...)?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Return sum of the column

Hi @Eagle77 ,
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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Super User IV

## Re: Return sum of the column

Hi @Eagle77 ,
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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors