cancel
Showing results for
Search instead for
Did you mean:
Responsive Resident

## 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])

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
1 ACCEPTED SOLUTION
Responsive Resident

I believe I have this working.  I used the following:

SVCMIX Install % =
DIVIDE (
CALCULATE(SUM(RevenueByTech[INSTALL])) ,
CALCULATE(SUM(RevenueByTech[SVCMIX Total]))
)
1 REPLY 1
Responsive Resident

I believe I have this working.  I used the following:

SVCMIX Install % =
DIVIDE (
CALCULATE(SUM(RevenueByTech[INSTALL])) ,
CALCULATE(SUM(RevenueByTech[SVCMIX Total]))
)

## Helpful resources

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors