Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Working with Multiple Fact Tables & Dimension

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.

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    The cross filter direction should be Single for all relationships.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      That actually worked! Can you please tell me why? 

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        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.