Having only one relationship between two metric tables is causing havoc

[mehlenbae2]

• I have two metrics that I show on one tab by "Person".
• I have another tab that shows the same two metrics by "Manager".
• On both tabs I have a slicer that you can select the person or manager and see their specific metrics.
• Each metric has its own Table 
• I put a relationship between both Metric1 and Metric2 tables that connect the "Person" column. So the two metrics show the persons specific scores on my "Metric by Person" tab
• An issue arises when I go to my "Metric by Manager" tab and select a manager Metric 2 shows correctly but Metric 1 does not.
  • This makes sense because of the relationship I created as it is connecting "Person" to "Person" and not "Manager" to "Manager" on both Metric tables. I know that I cannot have more than one relationship between the two Metric tables (I was thinking I could create a relationship between "Person" in Metric1 to "Person" in Metric2 AND "Manager" in Metric1 to "Manager" to Metric2. 
• To remedy this I created a relationship between metric ID's between the two metric tables but I have an issue because there are some unique Metric ID's in both metric tables so it doesn't show all of the data.
• Creating a relationship between "Person" to "Person" on both metric tables seems to get me closer to where I want to be however, only one the metrics show correctly on my "Metric by Manager" tab. 
• I'm thinking I need to make a measure for Metric1 on my "Metric by Manager" tab but am unsure on how to make a measure that looks at the slicer and averages a "Met Metric Percentage" column.. I am very new to DAX.

There may be another way to do this but I am new to PBI and am having trouble with understanding the relationships and the limitations.. I hope this makes sense.

**I am unable to post pictures or post my PBI due to the sensitivity of this data, sorry I tried to explain the best I can**

[amitchandak]

@mehlenbae2 , Are you using inactive join and userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[mehlenbae2]

So the only relationship I have connecting the two Metric tables (Metric1 and Metric 2) is the "Person" to "Person" column in each Metric table. This relationship is currently Active. Its Many to Many and shows correct metrics in the "Metrics by Person" tab. 

However, when I go to my other tab "Metrics by Manager" only Metric2 is correct. Metric 1 is incorrect and seems to be calculating wrong.

[mehlenbae2]

This is how it looks:

Tab 1: Metric by Person

Select Person to see their metrics

Slicer:

Person 1

Metric 1 (all correct numbers)

40%

30%

98%

89%

88%

90%

Metric 2 (all correct numbers)

90%

99%

21%

76%

99%

100%

Tab 2: Metric by Manager

Select Manager to see their teams metrics

Slicer:

Manager 5

Metric 1 (incorrect numbers)

12%

99%

100%

10%

88%

94%

Metric 2 (all correct numbers)

44%

75%

33%

99%

100%

92%

Active Relationships

Table: Metric 1, Column: Person *.* Table: Metric 2, Column: Person