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