Userelationship function giving blank results.

[rushikesh_27]

Hello all,
I'm trying to use the userelationship function for a model.
I have 3 tables. Calendar, Shipment, Sites

Where Calendar(date)is connected to 2 dates of Shipment( early_ship date-active, loddte only-inactive) 

Sites(wh_id) is connected to Shipment(wh_id - active)

I'm trying to calculate the sum of Cases loaded(loose,layer,full pallet) based on loddte only.

DAX  used- calculate(sum(Shipment(Loose Sc Loaded)),userelationship(Calendar(Date),Shipment(Loddte only))

There are values for any dates filter, but still getting blank values. (Never seen blank values for userelationship function)
I have the same date type.
I'm using Calendar Date as filter. Site(Wh_id) as another filter to select sites.

Can I know what is it that I'm missing what should I pay attention to?

[amitchandak]

@rushikesh_27 , Make sure date table have all the dates.

Makse sure that Loddte only date have no time stamp - Change data type to datetime and select format with time. Time stamp should be 00:00 or 12:00.

if that is anything other than that then create a date column

Loddte only date = datevalue([Loddte only])

join date with that and use

[rushikesh_27]

Thank you for the support.
Made sure that the date does not have any time stamp. The Calendar date is having all he dates as well.
Still shows blank values.