filter in measure

[netanel]

HI All

I have the following formula:

Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day]) return _MTDA-[Net USD average per Day for Budget 2021]

but I want that "Net USD average per Day" Will arrive only after filtering 

the filter is column Source filter "IN"

Anyone know how to do this?

Thanks!

Attach a picture of my filter column

[amitchandak · Accepted solution]

@netanel , try like,  based on what I got

Diff$ Budget = Var _MTDA = CALCULATE([Net USD average per Day])
return calculate(_MTDA-[Net USD average per Day for Budget 2021], [Source] = "IN")