Forum Discussion
Divide Row Value with a measure
Hi everyone, I have a survey which can be completed by several people from the same company. I want the average score per category and this is done by taking the value in the score column and div...
Here is a measure expression you can try
Avg for Company and Category =
CALCULATE (
AVERAGE ( Table[Score] ),
ALLEXCEPT (
Table,
Table[Company],
Table[Category]
)
)Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeHere is a measure expression you can try
Avg for Company and Category =
CALCULATE (
AVERAGE ( Table[Score] ),
ALLEXCEPT (
Table,
Table[Company],
Table[Category]
)
)
Pat