Dear All
I have a power Pivot with the following coloumns
Employee Name
No of Transactions
What I need is to create a measure that sums the distictcount of the employees.
I have created a measure called dis Count and used the following formul
=DISTINCTCOUNT('Open'[Asst Name])
this will give me a value against each employee which is 1 and in subtotal I have 96 total employees
I also have created a rank measure with follwoing formula
rankx(all('Open'[Asst Name]),'Open'[Count of _Till], ,0)
What I need to do is create another measure that will divide each rank for each eployee by the total of employees (i.e. 96)/10
I need a formula to divides the rank by sum of disticntcount of employee but I get an error saying
The SUM function only accepts a column reference as an argument.
what I want is to divide each rank by the number in the subtotal row of the pivot table
any help is apprecaite it
Bookmarks