Calculate Percentage using SUM based on EE ID and Week Ending Date
Hello - I think this is a fairly easy thing, but I can't figure it out. I'm trying to calculate work order mix percentages for Install work orders, Service work orders, and Upgrade work orders BY TECH (EE Number) and BY WEEK ENDING date. I have the number of install, service, and upgrade work orders on the record, and I created a column to calculate the total. The issue is if I calcualte the percentage using a divide, the percentage gets summed. I need to create a measure to group by tech and week ending date, but I'm not sure how to do it. I want to display the resulys by Tech and Week Ending Date.
SERVICE MIX INSTALL % = DIVIDE(RevenueByTech[INSTALL], RevenueByTech[SERVICE MIX Total])