Forum Discussion

mfaber's avatar
mfaber
Frequent Visitor
9 years ago
Solved

Creating relationships between one to multiple tables

Hi,

 

I have two data tables and two assist tables, one assist is a calender table and the other is for filters. (As I need unique values to create a relationship between two columns)

I have a Product Category column in both data tables. For example I have two visuals, one is based on DataTable1_Product Category and the other is based on  DataTable2_Product Category, both tables containing multiple values that means creating relationship between these two is not possible (as far as I know one of them has to contain unique values only). So I created an assist table containing only the unique Product Category values called filter table, to create a relationship between the assist table's Product Category and both the data table's Product Category columns. But here comes the issue, it only allows one of these relationships to be active and now one of my visuals is not filtered.

Is there any solution to this?

Any help is greatly appreciated, thank you! 

  • The reason for the error message is, that you enabeld "Cross filter direction" into "both" directions.

    Change this option to "single" for your existing relationships - then you are allowed to create more relationships on your "_filter" tables.

    (I uploaded a corrected verision of your pbix-file to your onedrive share.)

     

    Does this solve your issue?

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi mfaber

     

    Can you share some data and the model diagram to find a suitable solution.

     

    Cheers

     

    CheenuSing

    • mfaber's avatar
      mfaber
      Frequent Visitor

      Hi Anonymous

       

      I can't share the whole table, but I created a sample for Excel and Power BI and I uploaded them here:

      https://1drv.ms/f/s!ApNIcC8uXzkkguRt25dR0TI3SuPzJA

       

      It's just a quick sample, my issue is that the slicers doesn't affect both cards, just one (the one with the active relationship).

      • MEhrenmueller's avatar
        MEhrenmueller
        Icon for Most Valuable Professional rankMost Valuable Professional

        The reason for the error message is, that you enabeld "Cross filter direction" into "both" directions.

        Change this option to "single" for your existing relationships - then you are allowed to create more relationships on your "_filter" tables.

        (I uploaded a corrected verision of your pbix-file to your onedrive share.)

         

        Does this solve your issue?