Forum Discussion

PerryJL's avatar
PerryJL
Regular Visitor
7 years ago
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...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi PerryJL,

Based on my test, it could work on my side:

Could you please offer your sample file to have a test if possible?

 

Regards,

Daniel He

  • PerryJL's avatar
    PerryJL
    Regular Visitor
    7 years ago

    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's avatar
      v-danhe-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      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