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])
Any help would be appreciated!!
| RDO Name | Site Manager | Location | LOB | Tech Name | EE Number | Hire Date | Term Date | Status | Week Ending | Average Weekly Revenue | INSTALL | SERVICE | UPGRADE | SERVICE MIX Total |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 10/23/20 | $5,000 | 14 | 19 | 7 | 40 |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 10/23/20 | $4,000 | 13 | 14 | 8 | 35 |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 10/30/20 | $2,000 | 16 | 19 | 4 | 39 |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 10/30/20 | $3,500 | 17 | 20 | 6 | 43 |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 11/6/20 | $3,000 | 20 | 12 | 5 | 37 |
| RDO 1 | SM 1 | LOC 1 | LOB 1 | John Smith | 123456 | 8/31/15 | | Active | 11/6/20 | $4,000 | 15 | 20 | 3 | 38 |
