Chart total doesn't match table total

[wbhite]

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 Hours]) + SUM('Labor Data'[OT Hours]) ).  When I apply this measure to the bottom table visual with >=40 set, it works fine and shows the correct total number of employees at 390.  However, when I do the exact same thing with the chart above, it ignores the filter altogether and shows the incorrect total of 637.

Any ideas?  Thanks so much.

[mahoneypat · Accepted solution]

You could use a measure like this in the chart.

Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))

Pat

[wbhite]

This one worked.  Thanks!

[wbhite]

Thanks, @amitchandak, but that new measure still doesn't work on the chart.  It works on the table visual, though.

[amitchandak]

@wbhite , You need to use a measure. Assume you have measure total Hour 

Sumx(filter(values(Table[employee]),[Total Hour] >= 40), [Total Hour])