How to filter report by two relationships

[Vygintas]

Situation: Im creating report for HelpDesk. Single user can create many tickets and single user can receive many tickets. I want to Slice report by how many tickets user created and how many tickets user created.

Problem: When I select user from slicer, it slices by tickets created by that user (this is according to relationship). But I want to also be able to slice by tickets he received to solve. How can I accomplish this?

[amitchandak · Accepted solution]

@Vygintas , You need join all dates with a common date table. You will get one active and other inactive relationships. Inactive relationship can be activated using userelationship

refer similar

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

And files after signature

[Vygintas · Accepted solution]

I ended up by creating two identical tables for tickets. And table "users" has two relationships to "tickets_for_agent" and "tickets_by_authors". Now when I select user, I get both how much tickets he created and how much he got to solve.

To create such table I used: 

tickets_for_agent = CALCULATETABLE('tickets')

[amitchandak · Accepted solution]

@Vygintas , You need join all dates with a common date table. You will get one active and other inactive relationships. Inactive relationship can be activated using userelationship

refer similar

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZU

And files after signature