How to calculate ABS value

[Chelsea_Yu]

Hi,

I need ur help that I need to calculate the difference between the number of actual sales and forecast sales, but the positive value and negative value shoudn't be offset, so I need to calculate the absolute difference. And here is my situation, please refer to the link:

https://drive.google.com/file/d/1-JcZDiK5D7cm9BwCj4h4g7o_u-g1rnlX/view?usp=sharing

[Fowmy · Accepted solution]

@Chelsea_Yu 

You can use the following measure:

AbsDiff = 
SUMX(
    CROSSJOIN('Product list','Channel list') ,
    ABS([sum of actual] - [sum of forecast])
)