This content has been marked as final. Show 2 replies
I am trying to get the count of employee, who are above or below the average / median salary. However getting some challenges.
Have tried these: Count(if([CTC (USD)] < Avg(Total [CTC (USD)]),[Employee Name]))
But the challenge is that the Average is getting calculated for entire population, which is giving the wrong analysis. Data has all job levels and when I draw graph at job level, average should be calculated individual job levels. Comparing salary with lower job level with higher is not the right way.
Have attached the dummy data. Please help.