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 ...
Need Help
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

      • anwarbi's avatar
        anwarbi
        Helper III
        3 years ago

        Hi,

         

        I want to compare the scores of a client lets say 'ABC" with other clients called as peer group which is dynamic based on slicer selection (so there will be different clients grouped together) and I want to represent them in a single chart, hence I have created duplicate table inorder to fit both the client and peer group in a single chart.

         

        Thanks