Forum Discussion

Chelsea_Yu's avatar
Chelsea_Yu
Regular Visitor
4 years ago
Solved

How to calculate ABS value

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

 

 

 

 

 

Absolute Value
DAX
Nead Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Chelsea_Yu 

    You can use the following measure:

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

1 Reply

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    Chelsea_Yu 

    You can use the following measure:

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