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.