Forum Discussion
How to filter report by two relationships
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')
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: