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), ...
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.

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.