Calculated Measure that ignores slicers and filters

[dfsadvantage]

I have a table of detailed records in a matrix visual. I am trying to create a caoluclated measure that sums all values in a column of that table, which ignores any date filters or slicers. I tried creating the following, but as soon as i select a date the values get filtered.

5xTotal = CALCULATE(SUM(MergeProjActual[SportsIOPlayerGameStats.5x]),ALL(MergeProjActual[SportsIOPlayerGameStats.5x]))

[camargos88 · Accepted solution]

@dfsadvantage ,

Here you are only ignoring the filter applied to the column [SportsIOPlayerGameStats.5x].

5xTotal = CALCULATE(SUM(MergeProjActual[SportsIOPlayerGameStats.5x]),ALL(MergeProjActual[SportsIOPlayerGameStats.5x]))

If you need to remove all the filter use :

5xTotal = CALCULATE(SUM(MergeProjActual[SportsIOPlayerGameStats.5x]),ALL(MergeProjActual))