Forum Discussion
Need help filtering two tables
Hi. I have two HR datasets, one for recruitment and one for resigns. I want to create visuals showing how many recruitment and resignation happen filtering by month and by branch. Currently, I filter by month or by branch seperately it works fine. But if I put on both filter by selecting only specific month and branch, it doesn't work. I suspect I'm missing something in the relations.
Please kindly help.
Ryanmoe138 , Calendar and Branch_ID Table should have 1-Many should have recruit and resign table. recruit and resign should not join with each other
refer if needed
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
1 Reply
- amitchandakSuper User
Ryanmoe138 , Calendar and Branch_ID Table should have 1-Many should have recruit and resign table. recruit and resign should not join with each other
refer if needed
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda