Can't get the correct total

DAX DAX Calculations
13

Hello @mno,

I guess this is what you’re trying to achieve.

Totals under one measure
Totals under one measure945×690 56.7 KB

I’m also attaching the PBIX file for the reference as well as providing a link below where a post has been created by one of our expert member @Greg. He has covered all the aspects about how one can rectify their incorrect totals.

You can furthermore, trim down your measure by eliminating the variables which are not required. Below is the alternative measure provided for the reference -

Measure 1 = 
VAR Calc = ADDCOLUMNS(
                VALUES( Dates[Date] ),
                    "@OL",
                IF( ISBLANK( [OL RE] ) ,
                    BLANK() , 
                        CALCULATE( [OL RE after 12] , PREVIOUSDAY( Dates[Date] ) ) ) )

VAR Result = SUMX( Calc , [@OL] )

RETURN
Result

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

Thanks & Warm Regards,
Harsh

WrongTotal_v2.pbix (151.7 KB)