How to count rows in PowerPivot with a specific value

[Jo2710]

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

[mikeTRON]

Well you can write a calculate formula to do this, but it might be easier for you to write a helper column or two to give you a flag to count instead of having all the logic baked into ONE measure.

[Jo2710]

Thanks mikeTRON, I've tried to do both but aren't having much luck.
My approach was to count rows with a specific value but I can't work out how to set the value to the person in question whilst ignoring the filter on the person and counting how many times their name appears in a separate column. Is it possible to do this in PowerPivot?
Thanks
Jo

[Jo2710]

So I thought I was getting close but now I'm not so sure!

I thought that the below would count the number of times a each name was shown in the table, it does but it ignores the filters applied within the pivot table. I'm not sure where to go from here, any ideas?
CALCULATE(COUNTROWS('PhoneData 1'),FILTER('PhoneData 1',[Connected]=earlier([Called])))

Thanks
Jo