Forum Discussion
Solved
Create Table Relationship
Hi, I am trying to join the following three tables without success. Can someone please help? Currently I have joined the Date table to Calls and Agent Times tables using Call Date. A...
Do the agents belong to a company? Is that an attribute you could move up to the Agents table? What are you trying to calculate off the Agent Times table?
All the agents have a company; it is like different branches. Using the company I filter and show the Total Calls, Total Duration, etc. I moved the Company to the Agent table and that created different problems. I think many to many problems. Then again, it is not just the company, as I mentioned on my original post, I will have many filters and I will have to move all of them up. That didn't work.
Could you perhaps share your .pbix file? What are you trying to calculate off the Agent Times table?
Sorry, too much sensitive information and organisation data in pbix.