Column aggregating across all employees

[Surveys]

I am trying to show daily employee hours, but am having issues. The image of the table model shows the relationship I have between date (dim_date), employee table (harersemployee) and payroll (harperspayroll) table. The image of the report is also shown (reference HRW Hours). What I believe is happening is that the payroll amount is summed for all employees and displaying that information. I am unsure why if I have a relationship between user account id and the date, why its not properly filtering the individual employee account. Any assistance is appreciated.

[MFelix]

Hi @Surveys ,

You are refering to the HRW Hours column in your matrix correct? Usually when there is this type of values that are a single value acrros all the visualization has to do with relationships that don't exist between two tables.

Can you tell if the HRW hours comes from a different table than the Employee Name and how are they related? altough you have an image of the setup it's not very practical to make a mockup data if you can share one and expected result would be great.