Forum Discussion
Solved
Calculate Sum based on Column Status and Cross Referencing Tables by EmployeeID
I have a slicer on my page with the DisplayName showing the agents in my company from Table 2. In Table 1, we use the ReferenceID to track which agent put the entry into the system. These tables have...
Hi PerryJL,
Ok. It's pleasant that if your problem could be solved, you could mark the reply as Answered to close this topic and if you have any questions you can contact me.
Regards,
Daniel He
Not sure what happened here. I went through and re-imported all the data, taking care of how it was transformed, and essentially copy and pasted the formulas I had and it all works as expected. I am guessing there is a flaw in the first attempt dataset that is causing the issue.