Remove the effect of the Date slicer from a measure

MBRA = 
VAR _md = MAX(MBRA_Demo[Date])
//VAR _base = FILTER( MBRA_Demo, MBRA_Demo[Date] = _md )
VAR _result = 
SUMX(
    ADDCOLUMNS(
        SUMMARIZE(
            MBRA_Demo,
            MBRA_Demo[Num]
        ),
        "@PUB", CALCULATE( MAX( MBRA_Demo[Balance] ), MBRA_Demo[Date] = _md) 
    ),
    [@PUB]
)
RETURN
_result

I would like for this measure to not be affected by date slicers on the report. What am I missing?

  • MBRA_Demo table increases by the addition of new or already existing records on a daily basis, one unique record id per day.