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
Super User IV
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]))

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

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

Proud to be a Super User!

3 REPLIES 3
Super User IV
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]))

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

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

Proud to be a Super User!

Helper III

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

Super User IV
Happy to help! Yeah, me too! 🙂

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

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

Proud to be a Super User!

Announcements