cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpatel2020 Frequent Visitor
Frequent Visitor

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

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.

 

 

 

 

 

 

2 REPLIES 2
Community Support Team
Community Support Team

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

@dpatel2020 ,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dpatel2020 Frequent Visitor
Frequent Visitor

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

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.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors