Calculated Table not filtering based on slicer

[MindfullyLost]

I am trying to get a calculated table to aggregate based on the selection in a slicer. It seems to simply ignore what is selected in the slicer and calculates the same values in the table regardless. I have some measures shown further below that I used for troubleshooting and they all work as intended. I'll also attach a screenshot of the relationships.

I have worked with chatgpt to try 20 different variants for producing EWS_Summary but nothing has worked. I'm about to give up and accept that this cannot be done which would be disappointing. It seems to be an issue with Context Filtering and the nature of ADDCOLUMNS.

This is my DAX to create a table:

EWS_Summary = 
ADDCOLUMNS (
    SUMMARIZE (
        EWS,
        EWS[Student Number]  -- Group by student number
    ),
    "Attendance Present Days",
    CALCULATE(
        SUM(EWS[Attendance Present Days]),
        EWS[SchoolYearTerm] IN VALUES(TermSelection[SchoolYearTerm])  -- Apply slicer filter for term
    ),
    "Attendance Membership Days",
    CALCULATE(
        SUM(EWS[Attendance Membership Days]),
        EWS[SchoolYearTerm] IN VALUES(TermSelection[SchoolYearTerm])  -- Apply slicer filter for term
    )
)

Here are some Measures I created for troubleshooting, all work as intended:

CheckFilter = 
CALCULATE(
    COUNTROWS(EWS),
    EWS[SchoolYearTerm] IN VALUES(TermSelection[SchoolYearTerm])
)

SumAttendance = 
CALCULATE(
    SUM(EWS[Attendance Present Days]),
    EWS[SchoolYearTerm] IN VALUES(TermSelection[SchoolYearTerm]))

TestSlicerSelection = 
CONCATENATEX(VALUES(TermSelection[SchoolYearTerm]), TermSelection[SchoolYearTerm], ", ")

[gmsamborn · Accepted solution]

Hi @MindfullyLost 

Calculated tables, like calculated columns, are evaluated at refresh time.  Slicers become usable after calculated tables and calculated columns have been evaluated.

I hope this makes sense.