Cumulative Totals not dynamic
Hello, Having difficulty making my cumulative total dynamic. In other words, my filters which are based on various categories in my data model are not working. These filters are working fine for my regular (not cumulative) totals. Below is the syntax: Cumulative Volumes = Calculate([Actual Volume], FILTER( ALLSELECTED('Flux Capacitor'), 'Flux Capacitor'[Date] <= MAX('Flux Capacitor'[Date] ) ) ) How can I ammend this syntax to get the cumulative totals to respond to my filters. Thank you!