Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

IF function measure

Hi all,   I am struggling with a measure as I would like to apply an IF condition.   I would like to sum up the costs, but IF Projects WBS starts with 'O.NO.XZZ', it should exclude the cost linke...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Check this measure:

    Measure = SUMX(ALL('Table'),'Table'[Cost])-SUMX(FILTER('Table',LEFT('Table'[Project WBS],8)="O.NO.XZZ"&&'Table'[GL account]="A7"),'Table'[Cost])

     

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Not sure what measure are you using, but if you want to sum the costs based on the condition you mentioned, do something like:

 

 

Your measure = 
CALCULATE(
    SUM('yourtable'[accountCost]),
    FILTER(
        Sales,
        LEFT(Sales[Project WBS],8) <> "O.NO.XZZ"
    )
)

 

 Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂