Forum Discussion

Icon for Helper I rank

Helper 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...

Icon for Helper I rank

Helper 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.

Icon for Super User rank

Super 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.

bininja
Helper I
7 years ago
parry2k I have one dimension table for each dimension. Each dimension table is connected to the facttables.

I earlier tried using one table as dimension table but I was then only able to makw the relationship wirh fact table on one column and that didnt work as I wanted it to.
bininja
Helper I
7 years ago
parry2k So there are same dimensions tables connecting to both fact tables not duplicates.
- parry2k
  Super User
  7 years ago
  bininja i'm surely missing something here, i think it will make sense to send some sample data with dimension (or put together pbix file with sample data) and let me know what it is not working.
  - bininja
    Helper I
    7 years ago
    parry2k Thanks for helping me out on this.
    
    Here is the file: https://filebin.net/f31diioljvh8zl40
    
    As you can see in the file, I have already sliced on one of the slicers. I want the other slicers on the page to sync with the selected value in the slicer and only show values in all slicers which are related to the chosen one. I hope you understand me.
    
    Let me know if there is something.