DAX for efficient inventory calculations based on FIFO principles

Based on inventory transactions, I would like to calculate the inventory balance based on FIFO medthod. I would like to calculate from which year of purchase, the balance is from. However, with bad DAX knowledge, my results on line levels are correct but not on total level:

This is how I have my measures:

Qty in = CALCULATE(SUM(Transactions[Quantity]),Transactions[Quantity]>0)

Qty in acc = CALCULATE([Qty in],FILTER(ALL('Retrieval Calendar'[Date]),'Retrieval Calendar'[Date]<=MAX('Retrieval Calendar'[Date])))

Qty out = CALCULATE(SUM(Transactions[Quantity]),Transactions[Quantity]<0)

Qty out total = 
    VAR StartOfTime = CALCULATE(MIN('Reporting Calendar'[Date]),ALL('Retrieval Calendar'[Date]))
	VAR EndOfTime = CALCULATE(MAX('Reporting Calendar'[Date]),ALL('Retrieval Calendar'[Date]))
	RETURN CALCULATE([Qty out],DATESBETWEEN('Retrieval Calendar'[Date],StartOfTime,EndOfTime))

Temp Balance Quantity FIFO = 
	VAR TempBalance = [Qty in acc]+[Qty out total]
	RETURN IF(TempBalance<=0,BLANK(),TempBalance)

Temp Balance Quantity FIFO LY = 
	VAR TempBalanceLY = CALCULATE([Temp Balance Quantity FIFO],DATEADD('Retrieval Calendar'[Date],-1,YEAR))
	RETURN IF(TempBalanceLY<=0,BLANK(),TempBalanceLY)

Balance Quantity FIFO = 
	VAR Balance = [Temp Balance Quantity FIFO]-[Temp Balance Quantity FIFO LY]
	RETURN IF(Balance<=0,BLANK(),Balance)

Then I did a quick fix for that by adding this measure

Balance Quantity = IF(HASONEVALUE('Retrieval Calendar'[Year]),[Balance Quantity FIFO],[Temp Balance Quantity FIFO])

It works fine as long as the end users don't make a filter on Purchase Year. Once they do that, the total shows the wrong numbers.

Really appreaciate if anyone has worked with this FIFO calculations before. Thanks

I am adding a picture of some additional measures