Dax- measure condition and betweent start-end days

[philongxpct]

i have a model with 4 tb:

ClientTb: 2cols                                              FactData: 4Cols                                    Time: 3Cols

Name|ID (1-------------------------------Many) ID|Type|Amount|Time (1---------------Many) Time|Year|Month

and FilterTb:

ID|Type|Startdate|Enddate

ex:

A|Iron|01/01/2012|A|01/04/2014|

A|Diff|01/01/2012|A|01/04/2014|

A|Iron|01/03/2016|A|01/01/2018|

B|Water|01/01/2012|A|01/04/2014|

My problem with calculate sum of Amount betweent 2 time:= Calculate(Sum(FactData[Amount],Filtertb(FactData,FactData[Time]>=Min(Filtertb[Startdate]&&FactData[Time]<=Max(Filtertb[Startdate]))

This measure will work if i make a relationship Filter to FactData when Filter[ID] is UNIQUE. 

Can some guys help me out. Thanks.

P/s: I use excel 365 vers.

[amitchandak]

@philongxpct , Try a measure like

Calculate(SumX(values(FactData[ID]),FactData[Amount]),Filter(FactData,FactData[Time]>=Min(Filtertb[Startdate]) && FactData[Time]<=Max(Filtertb[Startdate])  && FactData[ID]=Max(Filtertb[ID])))

[philongxpct]

@amitchandak  Thanks for helps. Sorry for long reply cos my internet prob. Function working, but Measure has the same values on [Type] - a manually column added to sepperate value purpose, just in filtertb, it doesn't exist on Factdata. Any chances ???.

Thanks for support, i'm achieve so much ^^!

[wdx223_Daniel]

@philongxpct 

Calculate(Sum(FactData[Amount]),Filter(FactData,FactData[Time]>=MinX(Filter(Filtertb,Filtertb[ID]=FactData[ID]),Filtertb[Startdate])&&FactData[Time]<=MaxX(Filter(Filtertb,Filtertb[ID]=FactData[ID]),Filtertb[Startdate]))