Caculating value according to a dynamic value

[Anonymous]

Hello Masters

I failed in sum the value according to a dymanic value as below ,  it returned the total instead from the filter ,  

can everyone tell the correct farmula

Failure 1

Measure1 = FIRSTDATE ( Table{date})

Measure 2 = CACULATE(SUM(Table{value},FILTER(Table,Table{date} = {Measure 1} )

Failure 2 

Measure 1 = MIN (Table {week})

Measure 2 = CACULATE(SUM(Table{value},FILTER(Table,Table{week} = {Measure 1} )

the reason I created Measure1 instead of caculating FIRSTDATE or MIN directly in CACULATE is  in my data items have different starting date with record  , I suppose they will not in the same timing when I am looking at result  on item level .

I want return with  0 , if the item does not have a record on the FIRSTDATE within the chosen periods  of group items 

thanks 

eric

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this one

Measure 1 = MIN (Table [week])

Measure 2 =
VAR mydate = [Measure1]
RETURN
    CALCULATE ( SUM ( Table[value] ), FILTER ( Table, Table[date] = mydate ) )

[Anonymous]

@Zubair_Muhammad

It works amazing , thanks Zubair