Forum Discussion
Running Totals using Multiple Filters
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!
Hi Kelly.
Here is my model. The inactive relationship is the BudgetSort which identifies my product group.
Here are the two tables separately that would like to join. Billing on the left, Budget on the right.
When I add Budget to Billing, the weekend numbers don’t tie with the correct date
Here is the DAX for the measure for Running Budget ABC
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,
Kelly
Did 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!