Forum Discussion

ldbello's avatar
ldbello
Frequent Visitor
6 years ago
Solved

Meassure Calculation

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...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi ldbello ,

 

You could try the following measure:

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

 

ldbello's avatar
ldbello
Frequent Visitor
6 years ago

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's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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.