Regarding data modeling

[dshah12]

I want to create relationship of employee with created by and approved by as they both have common manager name.

So basically I have filter of manager and in accordance to that I want to get data of total created by and approved by under specific manager 
I right now have relationship of Many -Many between Approved By and employee 

But when I am tracking for created by I am not getting accurate answers 

Created by	Approved by	item
abc	xyz	2
xyz	abc	3

Employee	manager
abc	bgh
xyz	uij

[Anonymous · Accepted solution]

Hi @dshah12 ,

I suggest you to inactive the relationship between [Employee] and [Created by]/[Approved by].

Measure:

Filter = 
IF (
    OR (
        MAX ( Table1[Approved by] ) IN VALUES ( Table2[Employee] ),
        MAX ( Table1[Created by] ) IN VALUES ( Table2[Employee] )
    ),
    1,
    0
)

Add this measure into visual level filter and set it to show items when value = 1.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dshah12]

Thanks a lot 
I wanted it to work out for all visuals on page as well as the cards 
How can I do that 

[VijayP]

@dshah12  Create a unique values of managers in another table and create to one to many to get the result