Forum Discussion
Anonymous
7 years agoNot applicable
Keep Slicer Filter but Ignore Column Header
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?
- Anonymous7 years ago[Actual for All Selected Months] =
CALCULATE (
[Actuals],
ALLSELECTED( 'Calendar' )
)
1 Reply
- AnonymousNot applicable[Actual for All Selected Months] =
CALCULATE (
[Actuals],
ALLSELECTED( 'Calendar' )
)