Need help to get value of a measure from Table 1 based on relationship from Table 2 and Table 3

[dpatel2020]

Hi there,

I have 3 tables.

Table 1 (Fact)

Column 1

Org 1

Org 2

Org 3

Org 2

Org 3

Org 1

Org 20

Org 21

Org 22

Org 20

Table 2 

Column 1

Org 1

Org 2

Org 3

Org 20

Org 21

Org 22

Table 3 Peers

Column 1     Column 2

Org 1            Org 20

Org 1            Org 21

Org 1            Org 22

Org 2            Org 20

Org 2            Org 22

Org 3            Org 20

Org 3            Org 21

I have a few measures created in Table 1.

Reporting requirement is like below :

In one visualisation, I need to show

Select Org : Org 1

Name of Org : Org 1          Value of Measure 1

Peers:

Name of Peer Org : Org 20    Value of Measure 1

Name of Peer Org : Org 21    Value of Measure 1

Name of Peer Org : Org 22   Value of Measure 1

How do I achieve this using DAX? 

Any help is appreciated.

[v-chuncz-msft]

@dpatel2020 ,

It seems that you may just add relationship and use table visuals.

[dpatel2020]

Hi there,

Thanks for your reply.

Could you please explain which relationships do I need to create?

Table 1 > Table 2 (M : 1)

Table 2 > Table 3 (1 : M)

Table 3 > Table 1 (M : M) ???

Thanks.