Running total

Vijaykumar_shan 

it seems that you dont have a dimdate . also i noticed that excepted is a measure not a column. 

modify your code as follow : 

m = 
        VAR mind =
            MINX (
                FILTER (
                    ADDCOLUMNS (
                        ALLSELECTED ( data[date] ),
                        "ex", [excpected]
                    ),
                    NOT ISBLANK ( [ex] )
                ),
                data[date]
            )
        VAR maxd = max(data[date])
            
        VAR res =
            CALCULATE (
                SUM ( tbl_name[actual] ),
                data[date] >= mind,
                data[date] <= maxd,
              
              REMOVEFILTERS ( data[date] )
            )
            
        RETURN res
            

let me know if it works for you , 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠