Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
You could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You could use a measure like this in the chart.
Overtime Employees = COUNTROWS(FILTER(DISTINCT(Table[employee]),[Total Hour] >= 40))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
This one worked. Thanks!
Thanks, @amitchandak, but that new measure still doesn't work on the chart. It works on the table visual, though.
@wbhite , You need to use a measure. Assume you have measure total Hour
Sumx(filter(values(Table[employee]),[Total Hour] >= 40), [Total Hour])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |