The total in table is incorrect

[novieee]

I have my table here and the individual data from each day is correct but when it comes to total it is now incorrect
the correct total should be 2,987,684

EXPPlatesPOS_UsableABARun =

VAR previousDate = PREVIOUSDAY(CalendarTable[Date])

Var prodPlates = CALCULATE(

    SUM('Load Plan'[4_Allocation2]),

    'Load Plan'[4_Cast/Exp] = "POS-EXP",

    previousDate

)

VAR ExpPlates = CALCULATE(

    SUM('Load Plan'[4_Allocation (pos plates)]),

    'Load Plan'[4_Cast/Exp] = "POS-EXP"

)

RETURN ExpPlates+ prodPlates

using slicer to get the dates

thankyou!

[novieee · Accepted solution]

Figured it out.