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