Forum Discussion
Divide Measure by a Column
I was missing something! My realationship was wrong. As soon as it set it to both ways, rather than single, everything worked as it should.
smather can you share sample data and relationship diagram? Also how you are visualizing the data? Create another measure for sum of working days to check what value you are getting.
Hi parry2k
Currently it's in a graph, so it can be filtered by month and also to give a YTD view too. Here's how things look -- I dunno how to share, so hopefully screen grabs will be sufficient.
The Ut col is a forumula - Ut = IF(AND(Timesheets[Workday] = "Yes", Timesheets[Utilization] = "Install & Service"), "1","")
Both workday and utilization are forumulas too:
Workday = IF(Timesheets[jobcode_1] = "Bank Holiday", "No",IF(
Timesheets[local_day] = "Sat", "No", IF(
Timesheets[local_day] = "Sun", "No", "Yes")))Utilization = IF(Timesheets[jobcode_1] = "1. Involve Tasks", "Non-Install",IF(Timesheets[jobcode_1] = "2. Service Calls", "Install & Service", IF(Timesheets[jobcode_1] = "Annual Leave", "Non-Install", IF(Timesheets[jobcode_1] = "Bank Holiday", "Non-Install", IF(Timesheets[jobcode_1] = "Sick", "Non-Install", IF(Timesheets[jobcode_1] = "Compassionate Leave", "Non-Install", IF(Timesheets[jobcode_1] = "Unpaid Leave", "Non-Install","Install & Service")))))))The number of work days per month is just a table:
The relationship is done on month.
Hopefully some of that helps!
I was missing something! My realationship was wrong. As soon as it set it to both ways, rather than single, everything worked as it should.