Forum Discussion
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 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.
You could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
4 Replies
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!
wbhite , You need to use a measure. Assume you have measure total Hour
Sumx(filter(values(Table[employee]),[Total Hour] >= 40), [Total Hour])
Thanks, amitchandak, but that new measure still doesn't work on the chart. It works on the table visual, though.
