Pesty sumx with absolute value

DAX DAX Calculations
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