Need Help

Hi, anithaMallam ;

You could try it.

Actual YTD =
CALCULATE (
    SUM ( 'InfoMart CostOut_newtest'[Value] ),
    FILTER ( ALL ( 'InfoMart CostOut_newtest' ), [month] <= 6 )
)

Target YTD =
VAR val =
    CALCULATE (
        SUM ( 'InfoMart Costout_Target2021'[Target] ),
        FILTER ( ALL ( 'InfoMart Costout_Target2021' ), [month] <= 6 )
    )
RETURN
    val

Target YTD =
VAR val =
    CALCULATE (
        SUM ( 'InfoMart Costout_Target2021'[Target] ),
        ALL ( 'InfoMart Costout_Target2021' )
    )
RETURN
    val

Because it's not clear what your actual table data looks like? , so not sure if your formula is correct, and the [DateKey] in your expression?
Or based on the simple sample data you provide, provide the result you want to output.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.