Get start date of open item

[Moody__01]

Hi, i work with items in progress and calendar date where i define the outstanding amount based on the selected date. In example : 

__Outstanding =

var _analysisdate = MAX('Calendar Table'[Date])

RETURN ABS(CALCULATE(SUM(Source[TransactionAmount]),

               Source[StartDate] <= _analysisdate,

              Source[EndDate]  >_analysisdate))

I would like to catch the min startdate for the items where outstanding is not equal to 0 in a card but it doesnt work. 
it will either send me back the min start date for the all the items in scope, or the min date of the items i do selct manually.

 

is there a way to calculate the min start date for items where the measure [__Outstanding] is not 0 ? i tried several things but im running out of idea..

thanks for your help,Olivier

[Moody__01]

Hi Kedar, thanks for your prompt feedback. I have replace the below with the measure instead and it works well.

best, Olivier

[Kedar_Pande · Accepted solution]

DAX Measure

MinStartDateWithOutstanding =
CALCULATE(
MIN(Source[StartDate]),
FILTER(
Source,
ABS(SUM(Source[TransactionAmount])) > 0
)
)

it will display the minimum start date where the outstanding amount is not zero based on the selected date in your slicer.