Sum of Column where value is negative

[AlEde]

Hi,
I'm new to Power BI and it's my first question of many.

I have a colum of PM Fess that contains negative values.
I would like a Measurment that would calcualte the sum only the negative Values,
and another that would Calculate only positive Values

My first attempt at calculating the sum of Negative values from

Expected Revenue = SUMX('PMO Reporting Data'[PM Fees] < 0)

[AlB · Accepted solution]

Hi @AlEde 

Try this

Expected Revenue = CALCULATE(SUM('PMO Reporting Data'[PM Fees]), 'PMO Reporting Data'[PM Fees] < 0)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[AlEde]

That worked 🙂
Thank you