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.