cancel
Showing results for
Did you mean:
Helper III

## Percentage of hours work per employee for each department

Hello! I could use some help with creating a measure that can calculate percent of hours worked per employee for each department

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV

## Re: Percentage of hours work per employee for each department

It should be something like:

Measure = [Hours] / CALCULATE([Hours],ALLEXCEPT('Table',[DIVISION]))

If Hours is a measure. If column:

Measure = SUM([Hours]) / CALCULATE(SUM([Hours]),ALLEXCEPT('Table',[DIVISION]))

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

3 REPLIES 3
Highlighted
Super User IV

## Re: Percentage of hours work per employee for each department

It should be something like:

Measure = [Hours] / CALCULATE([Hours],ALLEXCEPT('Table',[DIVISION]))

If Hours is a measure. If column:

Measure = SUM([Hours]) / CALCULATE(SUM([Hours]),ALLEXCEPT('Table',[DIVISION]))

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Highlighted
Helper III

## Re: Percentage of hours work per employee for each department

@Greg_Deckler  awesome thank you this worked perfectly! I love this community very helpful

Highlighted
Super User IV

## Re: Percentage of hours work per employee for each department

Happy to help! Yeah, me too! 🙂

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

#### Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors