cant copying formulae down a data set based on pivot table cells

Question

I realise this is probably the basic of basic  fundamentals of powerpivot but need to get an answer quickly to convince a team this is worth using. 

I have a pivot table  based on 2 imported tables from a SQL DB, the pivot table displays count of logins, another on count of staff. I need to work out the % of staff who are logging in at each site.

The calculation (logincount/staffcount * 100) for each row. Do you know if i need to  build this into the pivot table or if it needs to be external to the pivot, i have added to the adjacent cells external to the pivot and just reference the sales but i cannot copy the formulae down the whole set as i would normally in excel.

Can any one point me in the right direction.

Cheers 

Answer 1

What you want is a measure. Right-click the table in the PivotField List and create your formula there.

Answer 2

yep worked it out

=CALCULATE(DISTINCTCOUNT(logins[staff])/count(staff[staff])*100)

cool, with the slices to group it at any level, i is laughing.

Cheers