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
Daniel,
While anonymizing the data to share with you, I reimported a subset of the data and reduced the data set, copied and pasted all the same calculated column information...and it worked as expected. I'm going to dig back through the original data set and see what might be causing the issue.
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi 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