Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    7 years ago
    [Actual for All Selected Months] =
    CALCULATE (
    [Actuals],
    ALLSELECTED( 'Calendar' )
    )
Anonymous's avatar
Anonymous
Not applicable
7 years ago
[Actual for All Selected Months] =
CALCULATE (
[Actuals],
ALLSELECTED( 'Calendar' )
)