Keep Slicer Filter but Ignore Column Header

[Anonymous]

Hi, I would like to add a total column for each month keeping the slicer filter but ignoring the column header.

I have tried using = calculate([Actuals],allexcept([Months]), but this ignores the slicer filter (Date= Jan to Mar).

Could anyone provide guidance to solve this issue?

[Anonymous · Accepted solution]

[Actual for All Selected Months] =
CALCULATE (
[Actuals],
ALLSELECTED( 'Calendar' )
)