Forum Discussion
Solved
Running Totals using Multiple Filters
I have read many articles for two days on how to get a running total and have not found the solution I need. I'm trying to calculate the budget value from one table and filter the dates relevant to...
Hi LauraAshburn ,
As the relationship between "billing activities" and "Budget" is many to many,when you directly add the data to the table visual,it may duplicate the same value,the best way is to create a measure to get the value from budget you need :
_Budget = CALCULATE(SUM(Budget[Budget]),FILTER('Budget','Budget'[BudgetDate]=SELECTEDVALUE(billing_activities[Date])),'Budget'[BudgetSort]=5)And you will see:
For the related .pbix file,pls see attached.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
The calculation worked for the filter on BudgetSort, that's great! I am trying to get the running budget, not the running billing.
I got it to work!! Thanks so much!