Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Nathaniel_C
Super User
Super User

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] ) ) )


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
Nathaniel_C
Super User
Super User

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] ) ) )


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!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors