Currently have a table where I came up with a DAX calculation to come up with #Employees working on any specific job. It is working fine. Multiple Employees = DISTINCTCOUNT(TimeReport[Employee])
The came up with a measure if Job had more than 1 employee working on it, give me first nonblank and it is working fine.
Employee = SWITCH(TRUE(),
What Is not working is the totals for the first 5 columns in the data. Need to come up with a formula that will give me the accurate totals for those columns based on the selected Employee from the measure called Employee