Forum Discussion

jabrillo's avatar
jabrillo
Helper 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
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

jabrillo 

you can try to create a new column

alloc = CALCULATE(AVERAGE('Table'[Alloc Pct]),ALLEXCEPT('Table','Table'[Proj],'Table'[Emp],'Table'[Dept]))/CALCULATE(COUNT('Table'[Alloc Pct]),ALLEXCEPT('Table','Table'[Proj],'Table'[Emp],'Table'[Dept]))

then you can display the table visual directly.

 

pls see the attachment below