Forum Discussion

jabrillo's avatar
jabrillo
Icon for Helper I rankHelper I
2 years ago

Calculating Average

I have this table: Proj Emp Dept Yr and Mo Alloc Pct P1 Adam West HR January 2024 10% P1 Adam West HR February 2024 10% P1 John Doe Sales January 2024 20% P1 John Doe...
Need Help
jabrillo's avatar
jabrillo
Icon for Helper I rankHelper I
2 years ago

I want to average by emp and proj, then sum this value by dept.

_AAndrade's avatar
_AAndrade
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Try this measure:


The output will be: