Forum Discussion
How to filter report by two relationships
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?
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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUAnd files after signature
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')
2 Replies
- amitchandak
Super User
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-trend/ba-p/882970
Power BI HR Active Employee Tenure Bucketing, and Hired, Terminated, and Active employees: https://youtu.be/fvgcx8QLqZUAnd files after signature
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')