Meassure Calculation

[ldbello]

Dear all,

I am not able to obtain the right result. Could you help me please?

Issues	Reporting	Calc	Real Estimated
35,35	143	107,65	107,65
106,05	43	-63,05	0	Negative must be "0"
187,6	75	-112,6	0	Negative must be "0"
71,05	394	322,95	322,95
122,85	163	40,15	40,15
160,3	156	-4,3	0	Negative must be "0"
105,7	198	92,3	92,3
		383,1	563,05
MeasureCalc = IF([Issues]-[Reporting]<0;0;[Issues]-[Reporting])
Obteined wrong results "383,10"
or this Calc
(Issues-Reporting)*70%/2, If the result obtained is negative show "0"

[amitchandak]

Please share the formula for the issue and reporting.  Measure calculation depends(may) on the level where it happens so need to check that.

[ldbello]

Thanks a lot,

I do not have any issue, just only want the calc without negavite values using one or two ways as commented:

The calc/form is: MeasureCalc = IF([Issues]-[Reporting]<0;0;[Issues]-[Reporting])

							Expecting without negative values (-63,-113,-4)	Obtained
Issues	35	106	188	71	123	160	106	789
Reporting	143	43	75	394	163	156	198	1172
Sum	108	-63	-113	323	40	-4	92	383
Sum	108	0	0	323	40	0	92
							563

[v-eachen-msft]

Hi @ldbello ,

You could try the following measure:

Measure =
SUMX ( 'Table'; IF ( [Issues] - [Reporting] < 0; 0; [Issues] - [Reporting] ) )

[ldbello]

Thanks a lot,

It doesn´t work because I´m working without table, only meassures. Only want to keep out negative values, the calc must be 563.

Regards,

[v-eachen-msft · Accepted solution]

Hi @ldbello ,

I have updated my test file. You could download and refer to it.

My sample data may be a little different with yours because I used whole number.