Measure filter by two columns

[amalrio]

Hi Gurus, 

I need to filter my measure by two columns in the same table, I need the blue highlited value at the measure output (9,249.20)  but I am getting 27,999.02.

any help would be really appriciated.

[amitchandak · Accepted solution]

@amalrio , Try a measure like

Var _min = min('Date'[Date])
var _max = calculate(maxx(allselected(Table), Table[PlanStatDate]), filter(Table, Table[StartofMonth] =_min))
return
calculate(sum(Table[Forecast_rate_poh]), filter(Table, Table[PlanStatDate] =_max))