Var calculate table not working with filters

[Robert14358]

Hello All.

this is my DAX

AC Hrs =

VAR SUMTABLE =

CALCULATETABLE(

    SUMMARIZE(

        Dim_ACT,

        Dim_ACT[ACT_Key],

        "MAX",

        MAX(Fact_SNAPSHOT[SS_HRS_AC])

    ),

NOT ISBLANK(Dim_ACT[ACT_ID])

)

RETURN

CALCULATE(SUMX(SUMTABLE,[MAX]))

It works when no filters are applied, but when i filter it, the sub total do not update.

NO filters

With Filters

[Robert14358]

turns out the NOT ISBLANK(Dim_ACT[ACT_ID])) is causing this to happen for some reason

[Robert14358 · Accepted solution]

yeah FILTER() function is what i needed