DAX to calculate two Sumx columns

[1001]

Hi, I need to calculate the total ABS value between two columns of two tables. I'm just unsure of the syntax though. I have so far:

As you can see from the screenshot, the ABS Variance total should be higher than the Variance total.  It isn't. Just wondering where my DAX is incorrect.

Thanks All.

[Anonymous]

Hi @1001 

Whether you mean to calculate the sum of variances, you can refer to the following measure.

SUM_ABS Variance=SUMX(ALLSELECTED('Table'),[ABS Variance])

Best Regards!

Yolo Zhu

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

[1001]

hi Yolo, I appreciate that. I finaly got the right DAX, being:

ABS = SUMX(SUMMARIZE('Masterdata','Masterdata'[Material ID],"ABS Diff",ABS(SUM('Orders'[Ordered Qty])-SUM('Deliveries'[Delivered]))),[ABS Diff])

Many thanks.