Forum Discussion
Solved
Running Total Measure Won't Work With Filters
I have a running total Measure that is working Revenue Budget Running Total = CALCULATE( SUMX(BudgetByProduct,[REVENUE_BUDGET]), FILTER(ALLSELECTED('Calendar'[global_date]),'Calendar'[global_...
I have resolved this by changing the order of the creation of the measures.
Created a filtered sum then created another measure for the running total of that sum
Hi dbattin4
Why does one of your calculations use allselected and the other doesn't?
Allselected() remove all filters but the ones you have specificly selcted, so I just think you need to deleted that from your DAX and it should work fine.