subtraction of two columns

[Anonymous]

Hi,

I am trying the use the quick mesure to subtract 2 colums of value with mixture of positive and negative but my end result trun out to be a positive (adding to value together). how do i edit this.

Var Gross Margin =

(SUM('Sheet2'[Actual Gross Margin])-SUM('Sheet2'[Budget Gross Margin]))

[Mahesh0016]

@Anonymous 

Subtraction = ABS([Total UnitPrice]-[Total ListPrice])

[Anonymous]

Hi @Anonymous ,

Please have a try.

Create a measure.

Var Gross Margin =
ABS(SUM('Sheet2'[Actual Gross Margin])-SUM('Sheet2'[Budget Gross Margin]))

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila]

Hello you could add a calculated column in the table then use this measure you used.

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudo 👍

Follow me on Linkedin

[Anonymous]

Thanks, I have tried, but the numbers were in correct.  so i didnt use the ABS.