Forum Discussion

anwarbi's avatar
anwarbi
Helper III
3 years ago

Creating Multiple relationship between two duplicate tables

Hi,

 

I have two tables (one is duplicate) both have got same data. I have created a many to many relationship between two fields named as 'rating'. I want to create few more relationships between the two tables for 'Country' and 'region' field, but it seems since there is already an active relationship between 'rating' fields, it is not allowing me to create any further relationship.

 

I there a way I can create multiple relationship between idenitical fields of the two table. 

 

Thanks.

Need Help

6 Replies

  • HughLa's avatar
    HughLa
    Resolver IV
    3 years ago

    Hi anwarbi 

     

    You can only have one active relationship between two tables, the rest will be inactive. To activate the relationship you have to use the USERELATIONSHIP function.

     

    Regards

    Hugh

    • anwarbi's avatar
      anwarbi
      Helper III
      3 years ago

      Hi,

       

      I tried using USERELATIONSHIP function in a measure (as below) but it is not giving results.

       

      Distinct count of clients = CALCULATE(DISTINCTCOUNT('2021 (Peers-EDF)'[Client]),USERELATIONSHIP('2021 (2)'[Country],'2021 (Peers-EDF)'[Country]),USERELATIONSHIP('2021 (2)'[Regions],'2021 (Peers-EDF)'[Regions]))
       
      Is this measure incorrect
      • HughLa's avatar
        HughLa
        Resolver IV
        3 years ago

        What you are trying to achieve does not make complete sense. 

         

        Why are you connecting the two duplicate tables to each other? Would you be able to explain what you are trying to achieve, maybe we can find a better way to do it.

         

        Hugh