I have a power pivot table, which consists on Division, name of employees within that division and the count of transactions they completed.
I have created a measure (Called Rank) to rank each employee per division based on the highest number of transactions completed.
[Rank] = rankx(all('Open'[Asst Name]),'Open'[Count of _Till], ,0)
What I need to do now is to create another measure that will divided each Rank by the number of employees in per division.
What I have done is created a measure that calculated the distinct number of employees per division (Called No of Employees).
[no of Employees]=DISTINCTCOUNT('Open'[Asst Name])
This puts a 1 alongside each employee and the subtotal for Division AA is 96 (as an example) and subtotal for division BB is 144 and so on.
What I want to do is now create a measure that divides the rank by the subtotal of No of Employees.
My Table is called OPEN.
Basically I want a measure that does the follwoung
Rank / Subtotal of no of Employees /10
I cant seem to get my head round what formula I need to divided by subtotal per each division. I
Any help is appreciate it
I have created a measure (Called Rank) to rank each employee per division based on the highest number of transactions completed.
[Rank] = rankx(all('Open'[Asst Name]),'Open'[Count of _Till], ,0)
What I need to do now is to create another measure that will divided each Rank by the number of employees in per division.
What I have done is created a measure that calculated the distinct number of employees per division (Called No of Employees).
[no of Employees]=DISTINCTCOUNT('Open'[Asst Name])
This puts a 1 alongside each employee and the subtotal for Division AA is 96 (as an example) and subtotal for division BB is 144 and so on.
What I want to do is now create a measure that divides the rank by the subtotal of No of Employees.
My Table is called OPEN.
Basically I want a measure that does the follwoung
Rank / Subtotal of no of Employees /10
I cant seem to get my head round what formula I need to divided by subtotal per each division. I
Any help is appreciate it