DAX: SUM of Budgets for months where costs are available

[Talvien]

Hi!

I'd like to create a measure where I just have the sum of the Budget of all months where Costs are available (so only the first 5 rows in the example table below). I need it for the target value of the below visual.

[Baskar · Accepted solution]

1. Calculate(Sum(Budget),filter(cost<>blank())

2. if(isblank(cost),0,sum(budget))

[Talvien]

@BaskarThe first one works, thanks a lot!

@Beckham I guess this doesn't work since Budget and Costs aren't the same table?

[Beckham]

It should be Calculate(Sum(Table[Budget]),Table[Costs]>0)

Does that work?