Problem: Measure should only add up positive values

[Chris_23]

Hello,

i’ve got a problem with a measure which should only consider positive values from a target-actual comparison:

Measure = 
(SUMX (
    FILTER (Job, Plan[BudgetControl-Delta] > 0),
    Plan[BudgetControl-Delta]
) )

So the measure replaces negative values with blanks. But unfortunately in total it seems that the measure also includes the negative values:

Any ideas, how to improve the measure?

Thank you

Chris

[v-jingzhang · Accepted solution]

Hi @Chris_23 

Your measure looks good except that the first table parameter should be 'Plan' rather than 'Job' I think. 

Measure = 
SUMX (
    FILTER (Plan, Plan[BudgetControl-Delta] > 0),
    Plan[BudgetControl-Delta]
) 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.