Hi
I have a list of suppliers where each supplier has a group of employee job titles.
As there are hundreds of job titles i would like to display the top 5 job titles under each supplier in a bar chart. In order to do that i created a measure where I rank the count of employees with each job title.
Rank = RANKX(all('Raw Data'[Job Title]),CALCULATE(COUNT('Raw Data'[Employee type])),,DESC,Dense)
I got the below result.
As the next step i wanted to create a column where if the rank is <=5, i display the job title else I display the value as "Others".
But when i create calculated column using the above formula the rank shows only 1 as value.
How to create the rank calculation as a calculated column? if Im able to do that, I can then create another conditional column to partition the data to top5 and remaining Others.
3
Share
Report
All responses (
Answers (
