Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total based on multiple measures

Hello, I'm having a hard time getting a running total on a measure that depends on mutiple measures.  My typical pattern isn't working:   Measure 2: Calculate([Measure 1], DATESYTD(Calendar[Date])...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you for taking a look, here is what I get with this measure:

Increase Hours RT = CALCULATE([Increase Hours], DATESYTD('Calendar'[Date]))
 
Notice how the 2nd row is not a running total as I expect it.  It should be 2697.67, but it calcs to be 14,451.43.
 
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Share the link from where i can download your PBI file.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        This is really amazing, thank you for this! For my understanding and learning would you be willing to walk me through how you arrived at this solution? 

        I see you surface a table using CALCULATETABLE, and then SUMMARIZE it, but I'm not fully understanding the design pattern here and how it works.

         

        Again, thank you!