You can do

Step 1 calculate average Salary at department level : Avg Salary= Salary[remove avg: employee]

Step 2 assign avg salary to employ: Avg Salary[by:→ ‘employee by department’]

‘employee by department’ is a metric or property that map each employee to a department.

Hi,

Thank you for your reply, it helps.

I have my metric where i know the average salary by department and I have a list where each employee is assigned to a department.

When i apply your suggestion i have :

The problem is it’s not matching a unic average salary for an employee.

Any suggestion ?

Thank you

You may want to check you dimensions included in average salary and employee by deparment. Is there a Month or Year dimension included?

Dimension for average salary is departement and employee by department is a list so no dimensions set. There is no Month or Year dimensions included.

Thanks