DAX running total that has condition Filter

Hi,
I've been trying to see how to create a formula in DAX where the internal formula filter is not over ridden by the external in
pivot table, at least I think that is what's happening.

I've used 'VALUES' which works for one column condition, but if I'm using an index column to create running total and then
want another criteria I get stuck, I've tried ALLSELECTED, and nesting another filter.

This is more of a learning process than a real life problem, any suggestions welcome.

Workbook and test file containing what i used attached.

Sorry,
I'd like the running total column in the pivot table to respect the pivot table category and only show for , in this case category 'a',
so I would have a running total for 'a' but noting for b and c. The 'values' function nearly helps, but I can't use the 'values' function as it only take one column, and I need to work on two one for category and one for creating a running total, I've used index rather than date.

Hope that helps,

Richard.

Thank you Rory, exactly and thank you also XOR, I had been trying with 'keepfilters' but only used them for first
time yesterday. Am I right in thinking that in for example; CALCULATE(FUNCTION, FILTER (ALL(TABLE[ROW] ;

the filtered information is sent to calculate which performs imposes context transition and then that is fed
to the actual function, sum for example.


Richard.

Thank you for your help and taking time to answer,

Richard