I have visualisation show workers by weekly hours, but I want my visual to display on worker with more than 72Hrs per week.
Please see attached and am getting my sum of hours from column worked_Hours.
Solved! Go to Solution.
You may try to create a measure like below to get the visual as requested.
Measure = VAR workhours = CALCULATE ( SUM ( Table4[worked hours] ) ) RETURN IF ( workhours >= 72, workhours )
The Column workhours are daily worked hours and I have the sum of worked hours in week in report view which is fine, but I want the report to show only worked who have worked more than 72hrs .
Here is the sample file. If it is not your case, please share your data sample file. You can upload it to OneDrive or Dropbox and post the link here.