Hi

I'm new to PowerPivot and am struggling to write a measure to do what I need, here's a snippet of data that will help explain.

For each person I need to calculate the following:

Number of times called DONE
Number of times called and connected DONE
Number of times connected (not called) STUCK!!
Number of outgoing calls DONE

Week Beginning Called Connected Direction
1-Feb Jo Out
1-Feb Jase Jo In/Out
1-Feb Jo Jo In
1-Feb Jase Jo In/Out
1-Feb Jase Jase In
1-Feb Jo Jase In/Out


Can anyone help?

Thanks
Jo