Percentage of hours work per employee for each department

[Anonymous]

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

[Greg_Deckler]

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

[Anonymous]

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

[Greg_Deckler]

Happy to help! Yeah, me too! 🙂