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

    • DominoPBI's avatar
      DominoPBI
      Frequent Visitor
      3 years ago

      Are you able to put here some screenshots to let us understand what is your idea?