Forum Discussion
wbhite
Helper I
Helper IChart 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
mahoneypat
Microsoft Employee
Microsoft EmployeeYou could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
wbhiteHelper I
Helper IThis one worked. Thanks!