Creating Multiple relationship between two duplicate tables

[anwarbi]

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.

[DominoPBI]

Hi @anwarbi 

I reccommend you this article about USERELATIONSHIP. I think it will be helpful 

Power BI: DAX Function USERELATIONSHIP Explained (pragmaticworks.com)

[HughLa]

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]

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]

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]

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]

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