Use Table as a variable in a measure

[apiccolotto]

 Hello,

I need to create a Measure that first group the lines by Date (summarizing) and then return the minimum date that have the sum lower than zero.

I try to create the following measure, but it seems that I can't use table in the calculation (the underline text is an error).

Stock_Cover test =

var Table1 =

SUMMARIZE('Stock Cover','Stock Cover'[Date],"Quantity",sum('Stock Cover'[Sum of Init Stock - Outflow + On Orders[Volume]]]))

return CALCULATE(MIN(Table1.Date),Table1.Quantity < 0))

Thanks in Advance,

A.

[amitchandak · Accepted solution]

@apiccolotto , Try like

Stock_Cover test =

MINX(filter(SUMMARIZE('Stock Cover','Stock Cover'[Date],"Quantity",sum('Stock Cover'[Sum of Init Stock - Outflow + On Orders[Volume]]])),[Quantity]<0),[Date])

[apiccolotto]

Thanks a lots, it works.

A.