Two Tables, Two Relationships

[Anonymous]

The Background: I have 2 tables (UserAccount & Tasks). UserAccount has UserID. Tasks has UserID AND AssignedByUserID.

The Story: A user can take a task or a user can be assigned a task by a higher role user. A relationship exists between UserAccount.Userid == Tasks.UserID. So any visual only shows the user who has the task, not the Assigner

 The Problem: I want to see who assigns tasks and to whom. 

I see this as the classical SQL problem of showing all employees and their managers who are also employees. I know in SQL to create 2 aliases for the same table and compare the userids as manager or not. In Power BI I don't know how to do it.

UPDATE: I've written a DAX IF statement where IF UserID = AssignedByUserID, 0, UserID, but I still can't get the user's name.

UPDATE: I've used the link: https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Created a new table and linked it to Tasks.AssignedByUserID.

[amitchandak · Accepted solution]

@Anonymous , In Power BI You can create two joins one active and one inactive. And you can activate join using use relation.

refer example :

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

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

But as in this case you need filter both or you filter one and see others. You might need to copy the table.

Create one more copy of the table

User 1 = Distinct (User)

or

User 1 = user

If use name is available in , we sometime use from the fact for display purpose