Forum Discussion
Create Table Relationship
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?
You will need an Agent table that sits at the same level as the date table. It should contain the unique list of agents and that you can connect to the 'Agent Time' and Calls table to use to filter the model by Agent.
It doesn't work. I picked the wrong date to filter earlier. I tried to filter by Company where all the companies had records for a day but it shows all the agents for all the companies.
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?
I found why I was getting Many to Many error with Agent and Company. Same Agent name was found in more than one company. After sorting that out I moved the Company to the Agent table as you suggested and built the relationship. That is working now.
Thanks for your help.
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?