How to calculate average based on multiple dimensions
I would really appreciate for the guidance on the following scenario.
I have 4 columns Emp No, Designation, Salary and Year. And i want to calculate the average salary by designation for each year. But when I display Avg(Salary) measure against Designation and Year dimensions in a table on front end, I am getting same average salary value against all years for a particular designation.
Attached is the sample data with desired and current results i am getting.