Forum Discussion
Solved
Chart total doesn't match table total
Hello everyone, I'm having an issue with one of the visuals below. Basically, I want both to reflect the number of employees who worked 40+ hours (using my measure Total Hours = SUM('Labor Data'[Reg...
You could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
You could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
This one worked. Thanks!
