Forum Discussion
Running total not working as expected in matrix
Hi all, I have a running total measure which seems to work fine when plotted against a date only, however when I try adding it to a matrix with several additional text columns, it no longer works...
My bad, should Change the filter table to Calendar table. Give it another try:
Cumulative = calculate(sum('Transactions Table'[Cohort]),filter(all('Calendar'),sumx(filter('Calendar', earlier('Calendar'[Date])<='Calendar'[Date]),1))
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Thank you. I'm afraid I'm getting the same issue as with the other measures: it works when plotted only against the date, but as soon as I add another column it stops working 😞