cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Eagle77 Helper II
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
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] ) ) )


tot neg.PNG

 
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!




View solution in original post

1 REPLY 1
Super User IV
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] ) ) )


tot neg.PNG

 
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!




View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

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!

‘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

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

Community Summit North America

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

Top Solution Authors