Relationship issue with direct query and import mode table

Hello,

I am working on a composite model which has table coming from a direct query and sharepoint to power BI, both table are facts table. I am trying to connect both the table to a calendar table. I have a measure calculating sum from direct query as well as import mode but the date filter is not filtering the sum correctly , Or if i am filtering for any column from the import mode that is also not giving me the correct value. Is there any work around?

The calendar table is a static measure.

Any suggestions are welcome

regrads 

anonymus