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.