Filtering records based on a slicer

[MR2001]

I have the following calculated column that works correctly:

Total PCR = 
VAR Date1 = 'Table1'[date]
RETURN
CALCULATE (
SUM ('Table1'[Total] ),
FILTER (
'Table1',
'Table1'[date] <= Date1), 
FILTER( 'Table1', 'Table1'[Request_Type] = "Defect")
)

If I remove however the highlighted part and add a slicer based on [Request_Type] instead, it does not work correctly anymore. I was hoping a filter will change the way column calculates but it doesn't... Selecting "Defect" from the slicer does not produce the same result.

[Request_Type] column has three possible values: "Defect", "Enhancement", "Change".

How can I make it work based on a filter/slicer?

[Greg_Deckler · Accepted solution]

Have you tried creating that as a measure instead of a calculated column?

[MR2001]

Problem solved.
Measure:

Total PCR1 =
CALCULATE (
SUM ('Table1'[Total]),
FILTER ( ALL ('Table1'), Table1'[date] <= MAX ( Table1'[date] ) ),
VALUES(Table1[Request_Type] )
)

Note: the key was adding VALUES(Table1[Request_Type] ) as demonstrated in: http://community.powerbi.com/t5/Desktop/DAX-Running-total-by-another-column/m-p/10517#M2191