Forum Discussion

LauraAshburn's avatar
LauraAshburn
Helper I
5 years ago
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...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

LauraAshburn's avatar
LauraAshburn
Helper I
5 years ago

I haven't ever posted before. Where to up upload the .pbix? That way you can at lease see the measures, right?

amitchandak's avatar
amitchandak
Super User
5 years ago

LauraAshburn , You can upload to one drive or dropbox and share the link

  • LauraAshburn's avatar
    LauraAshburn
    Helper I
    5 years ago

    I saved it to my OneDrive but can't find where there is a url to use as a link.

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      LauraAshburn , right click and get shareable link. or check  some options like three dots

      • LauraAshburn's avatar
        LauraAshburn
        Helper I
        5 years ago

        I pasted the link in Message 10