Cumulative Balance Issue

[Antmkjr]

I want the Cumulative Balance Updated column to be the cumulative of Balance Current Month Updated

The below formula is not working:

VAR Result_in =
Total
+ IF (
Total < 0,
Total * -1
)
RETURN
CALCULATE (
Result_in,
FILTER ( ALLSELECTED( ( ‘Date’ )), ‘Date’[Date] <= MAX ( ‘Date’[Date] ) )
)

Also the below is not working

Cumulative Balance Updated =
CALCULATE (
[Balance Current Month Updated],
FILTER ( ALLSELECTED( ( ‘Date’ )), ‘Date’[Date] <= MAX ( ‘Date’[Date] ) )
)

Link to pbix:

https://drive.google.com/file/d/1LcEYNZFgxKRLDbOZelNYltgxBmmg6buA/view?usp=sharing

[amitchandak]

@Antmkjr , Try like

Cumulative Balance Updated = 
VAR Result =
     CALCULATE (
            sumx(SUMMARIZE('Date','Date'[MonthnYear],"_1",[Balance Current Month Updated]),[_1]),
            FILTER ( ALLSELECTED ( 'Date' ), 'Date'[Date] <= MAX('Date'[Date] )
            ))
    
RETURN
    Result

[Antmkjr]

Thanks, that works ! But why was my formula not working?

[amitchandak · Accepted solution]

@Antmkjr , I think across tables data is not getting added up in the context so forced that in suggested formula