Relationship issue with direct query and import mode table

[anonymus]

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

[lbendlin · Accepted solution]

Do not join fact tables directly.  Let your common dimension tables control the fact tables.

[Anonymous]

Please, could you explain the magic you did to connect sharepoint with direct query?

[lbendlin · Accepted solution]

Do not join fact tables directly.  Let your common dimension tables control the fact tables.

[anonymus · Accepted solution]

Thank you it worked smoothly