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

Hi ​@Elouan,

It sounds like you want each employee to display the average salary of their department, for example, every employee in HR should see the same departmental average.

Here’s how to do it step-by-step:

Create a metric for the departmental average as ​@Min Li suggested, e.g.

Avg Salary by Department = AVERAGE(Salary) BY Department

Reference that metric in your employee list, by linking through the Department dimension:

Employee Dept Avg = [Avg Salary by Department] BY Department

This will return the same average value for all employees in the same department.

If the result isn’t unique per employee, double-check that there are no extra dimensions (like Month or Year) in either metric otherwise the context won’t match.

If you still see multiple values per employee, could you share a screenshot of both metric structures? or could you please share the formula you’re using for the department average?
It’ll help us understand how the calculation is scoped and why it might not be returning a unique value per employee. Once we see it, we can guide you on the best adjustment. That’ll help check the dimension scoping.

Best,

Tobias