Forum Discussion

bininja's avatar
bininja
Icon for Helper I rankHelper I
7 years ago

Connect multiple fact tables with multiple dimension tables

Hi guys,

 

I have a issue with relationships.

 

I have multiple fact tables with multiple columns of primary keys.

Then I have multiple dimension tables where each table should be connected to a specific columns in each of the fact tables above with foreign keys.

 

The connections are working fine, but the issue is that while I am using the dimension tables as slicers, the slicers does not sync with eachother. I tried changing from single to cross relationship but that gives me ambigious error. I want them to sync so that when a slicer is used, the other slicers only show values for the filtered view and not the whole list.

 

Here is how the connections are set up.

 

Need Help

10 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    bininja you don't need cross filter to both, can you share relationship diagram you have.

    • bininja's avatar
      bininja
      Icon for Helper I rankHelper I
      7 years ago
      parry2k Thanks for your reply. The diagram is just as I have posted above. One to many relationship for all of them.
      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        bininja well then it shoudl work, one thing is not clear, do you have duplicate for each dimension or same dimension table connects to both fact, if it is the later one then everything should work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Guys, I have a similar problem. Was anyone able to get an answer for this? 

    I tried making the multiple fact tables to a flat (single) fact table by doing the merge in the power query. But my data is coming from the data warehouse and each of the fact tables is 7 Million rows+ (because there at aleast 10-12 primary keys common in both the fact tables). Any help would be very good.