Forum Discussion

EnderWiggin's avatar
EnderWiggin
Helper I
5 years ago
Solved

Running total calculation without filter?

Hi All, I created a running total calculation which counts from a start balance. The start balance contains the actual stock quantity, stock input output quantity before the actual month + actual mo...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    OK I think I found it, add "<" to this measure

     

    Looking good!

     

aj1973's avatar
aj1973
Community Champion
5 years ago

Hi EnderWiggin 

here you go

Use VAR to nest your measure into CALCULATE

 

EnderWiggin's avatar
EnderWiggin
Helper I
5 years ago

Hey aj1973 ,

 

thank you for your fast reply! I tried it, but the running total calculation does not work on this way (as it can be seen on the picture you shared)

m_StockIORunningTotal1 = 
var StockIODiff = [m_StockIODiffForRunningTotal]
var RT = CALCULATE(
	StockIODiff,
	FILTER(
		ALLSELECTED('Calendar'[0BeforeActualYearMonth]),
		'Calendar'[0BeforeActualYearMonth] >= [m_ActualMonth] && 'Calendar'[0BeforeActualYearMonth] <= max('Calendar'[0BeforeActualYearMonth]))
	)
return RT

 

    • EnderWiggin's avatar
      EnderWiggin
      Helper I
      5 years ago

      I downloaded the file and checked again but unfortunately your solution (in m_StockIORunningTotal) provides same result as the m_StockIODiffForRunningTotal which counts the start balance for running total. The 3rd visualization shows the running total correctly but the 0BeforeActual column is missing:

      Please see the details in this RunningTotalDemoWithCalendar1_aj1973

      file.

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        I didn't touch nor verify your calculations/measures. I just answered your request which is you wanted to see OBeforeActual coloumn in the Matrix.