'Assistance needed on how to show calls being transferred to Destination and from Origination

Please can someone assist me with this problem.

I am working on a dashboard that tracks calls from Origination to destination.

The current report allows to view calls from origination to destination but not the other way around.

My Table of call transfers

enter image description here

The table has calls from where they started i.e Origination and to where they were transferred i.e Destination.

The Call that comes from Origination and is transferred to Destination is a transfer out. But a call that happens from Destination and is transferred somewhere else is a transfer in.

Example.

Line 1 transfers out a call from Origination Id 56 "Online Helpdesk" to Destination Id 3 "Call Agent". This was one call. Then in line 6 The Origination is Id 3 "Call Agent" who transfers in the call back to Id 56 "Online Helpdesk" There was a total of 3 calls here. The 2 out of 3 calls could have came from some other Agent which is not important.

This is the relationship between my Calendar table and Call Center table.

enter image description here

This is my power Bi Visual.

enter image description here

What i need help with is how do i get the visual to filter and show me the transfer In calls for example the first line i select in transfer out. It should show me just the call agent with 3 calls.

Regards



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source