Forum Discussion
Solved
Filtering records based on a slicer
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),...
Have you tried creating that as a measure instead of a calculated column?
Have you tried creating that as a measure instead of a calculated column?
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