Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)+...)?
Solved! Go to 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
Proud to be a 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] ) ) )
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
Proud to be a Super User!
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |