Ok just reviewing this one,
Still trying to get my head fully around this.
So from what I’m understanding the opening balanced number is not calculating correctly,
Because when you place a dates filter on the table the ALLSELECTED is then only calculating within that selected context.
I think actually you could maybe fix this just by changing the ALLSELECTED to ALL.
Can we try this.
I explain the difference here
The ALL will always go back to the beginning of the dataset and calculated the cumulative total from then, which is what I’m thinking you actually need now.
Let me know.