create a new measure to calculate the difference

[pang22]

Hello,

How to create a new measure to calculate the difference between 2 columns?

Eg. 967,063 - 226,556

Thanks.

[v-zhangti · Accepted solution]

Hi, @pang22 

Sample data:

Measure = 
Var _N1=CALCULATE(SUM('Table'[Qty]),FILTER(ALLEXCEPT('Table','Table'[Month]),[Type]="OPN"))
Var _N2=CALCULATE(SUM('Table'[Qty]),FILTER(ALLEXCEPT('Table','Table'[Month]),[Type]="Order OH"))
Return
IF(HASONEVALUE('Table'[Type]),SUM('Table'[Qty]),_N1-_N2)

Is this the result you expect? Please see the attached document.

Best Regards,

Community Support Team _Charlotte

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

[lbendlin]

measures need aggregations.  So instead of saying

measure = [Column1]-[Column2]

you need to say

measure = sum(Table[Column1])-sum(Table[Column2])