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...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper 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's avatar
bininja
Icon for Helper I rankHelper 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.

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

    bininja I now understand what you are trying to do, here is the post which can helpt but not sure what is the use case you need to do this. Hope above link helps

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

      parry2k Thanks. This looks good. The thing I am not sure about is how this will work since I have multiple fact tables..?