Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is this the output you are expecting to see?
Expression:
Count(DISTINCT {<[Employee Number] = {"=[CTC (USD)] < Avg(Total [CTC (USD)])"}>} [Employee Number])
Given response on earlier post. Thanks