How to sum Negative and Positive numbers in power BI for a Measure

[vivek_rana]

I have 2 columns , sales and Profit with postive and negative values for both..     I need to create a measure in power bi Desktop to find the difference (Sales - Profit)....      Our difference will contain negative and postive numbers...   Now my query is how to consider the negative numbers as positive and sum them up with postive numbers.. Please find the attached screeshots. Please note difference  is not a column , its  a measure to be calculated in power bi. i am not able to attach excel .hopefully someone can help me in the community.. Thanks

[samdthompson · Accepted solution]

I think @AlexisOlson it needs one more step to get the rows responding the same way as presented:

[vivek_rana]

Thankyou so much...Thompson  🙂

[AlexisOlson]

Do you need your difference measure to preserve the sign at the individual product level or can you do this?

AbsDiff = SUMX ( VALUES ( Table1[Product] ), ABS ( [Sales] - [Profit] ) )

Where [Sales] and [Profit] are appropriately defined measures, e.g. Sales = SUM ( Table1[Sales] ).