Week Count in XTable based on date range with Inactive relation of Date Table

[mh2587]

I have two tables

1.Customer > Customer Name , Created Date

2.Date Table > Year , Month , Date , Week In Year
Now the scenario is: I want count the Week In Year(Date Table) But In the range of Created Date which is the column in Customer Table but the issue is the relation is inactive between customer and date table 

[amitchandak]

@mh2587 , Try a measure  like

=
var _max = maxx(allselected(Customer),Table[Created Date])
var _min = minx(allselected(Customer),Table[Created Date])
return
calculate( distinctcount(Date[Week In Year]), filter('Date', 'Date'[Date] <=_max && 'Date'[Date] >=_min))

[mh2587]

Thanks for the response but it's Not working