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://excelerato...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    The cross filter direction should be Single for all relationships.

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.