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.
 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

Based on these screens, I guess the problem is you created a running total on the [Increase Hours] measure. Try change the measure to a column if possible, If you really want a measure. Can you share the sample pbix with us, so can we make some test on it.

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly