Forum Discussion

Chris_23's avatar
Chris_23
Helper II
4 years ago
Solved

Problem: Measure should only add up positive values

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

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    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.