Rolling Totals

[kevinbrad06]

I've tried searching everywhere for this but I haven't found a result that helps yet. I'm trying to get running totals of values but I believe the fact I'm looking across multiple tables is breaking the total. It works fine when only including the columns from [items] but as soon as I the [quad_1] column it no longer creates the totals over the entire item. I can't add the quad column to the "FILTER(ALL())" because it isn't in the same table as the item columns. Any other way to do this that doesn't require redesigning how I'm bringing the data into the report?

[VahidDM]

Hi @kevinbrad06 

Try to add REMOVEFILTER(quads[quad_1]) to the calculate formula after the filter and see the result.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[kevinbrad06]

I tried it before and after the filter statement and it still didn't give the desired result. The desired result would be the table on the left but havin the quad_1 column included in the table as well.