Incorrect Totals when using Custom Time Intelligence DAX

DAX DAX Calculations
2

Hello @jcantillo11,

Thank You for posting your query onto the Forum.

You just need to create a small measure provided below in order to fix the total. Below is the measure as well as screenshot of the final results provided for the reference -

Sales Avg3MOffsetTest - Totals = 
SUMX(
    SUMMARIZE(
        dDate ,
        dDate[Year] ,
        dDate[Month] ,
        "@Totals" , 
        [Sales Avg3MOffsetTest] ) ,
    [@Totals]
)

Final Results
Final Results1420×576 149 KB

I’m also attaching the working of the PBIX file as well as providing the link of the post which was created by one of our expert @Greg on this very topic.

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

Important Note:

1. There’s a difference of $1 in the total between the results showcased into the picture and the results achieved. This must be because of the decimal portion issue.

2. In order to view the entire post, please click onto the link and not onto the “expand/collapse” button.

Thanks and Warm Regards,
Harsh

PBI 3Month Moving Avg Testing - Harsh.pbix (144.8 KB)