Working with Multiple Fact Tables & Dimension

[krixtsup3r]

Hi Guys, I have multiple fact tables that were in the center (see image below) then tags & calendar table. How can I connect them properly? 

I found this blog already: https://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/ and this guide https://www.youtube.com/watch?v=TnyRsO4NJPc but still can't work it out.

[Ashish_Mathur · Accepted solution]

Hi,

The cross filter direction should be Single for all relationships.

[krixtsup3r]

That actually worked! Can you please tell me why? 

[Ashish_Mathur]

I have never come across practical situations where i have to select Both in the Cross filter direction.  I have alays used Single and have been able to solve most (if not all) problems.

Perhaps someone else can pitch in to answer your exact question.