Pesty sumx with absolute value

DAX DAX Calculations
1

Hi,

I have tried to use HASONEVALUE but this problem is little different.

I have negavtive number coming in column

image

AB Error 2. I want to create a sum on it’s absolute value. So instead of 14,489 I should see 20,415.

https://drive.google.com/file/d/1R5c9_dIKqL6zxKMsmKzQcceZyXJ9Rj59/view?usp=sharing

Thanks,
-Ritesh

2

Hello @rit372002,

Thank You for posting your query onto the Forum.

Below is the formula provided for the reference -

Absolute Value (Correct Totals) - Harsh 1 = 
SUMX(
    SUMMARIZE(
        'Historical Fcst' ,
        'Historical Fcst'[ITEM_NUMBER] , 
        'Historical Fcst'[LOCATION] , 
        'Date'[Start of Week] , 
        "Grand Total" , 
        [absolute value] ) , 
[Grand Total] )

And also providing below the screenshot of the result -

Correct Totals
Correct Totals1323×772 114 KB

I’m also providing a link below where a great post was created by one of our expert member @Greg about how to fix the incorrect totals.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Note: In order to view the entire post, please click onto the link and not onto the “Expand/Collapse” button.

Thanks and Warm Regards,
Harsh

2 Likes
3

This is absolutely amazing!!! Thanks so much @Harsh

4

Hello @rit372002,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to help you.

Thanks and Warm Regards,
Harsh