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 slicer filter (Date= Jan to Mar).
 
Could anyone provide guidance to solve this issue?
 
  • Anonymous's avatar
    Anonymous
    7 years ago
    [Actual for All Selected Months] =
    CALCULATE (
    [Actuals],
    ALLSELECTED( 'Calendar' )
    )

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    [Actual for All Selected Months] =
    CALCULATE (
    [Actuals],
    ALLSELECTED( 'Calendar' )
    )