Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
How to create a new measure to calculate the difference between 2 columns?
Eg. 967,063 - 226,556
Thanks.
Solved! Go to 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.
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.
measures need aggregations. So instead of saying
measure = [Column1]-[Column2]
you need to say
measure = sum(Table[Column1])-sum(Table[Column2])