butlerrbrian
New Member
- Joined
- Jan 30, 2013
- Messages
- 37
I am creating a measure that allows me to calculate the number of contacts (phone/email) made for each enrollment of a new customer. Looking at the table of phone data, I can easily derive the total of phone calls with:
CALCULATE(SUM('Phone Data'[Outbound Call Count]))
This works equally well with email data.
I have another table for enrollments, and each row represents a single enrollment. Knowing that the total number of rows with a creation date in February, 2013 is 573, I measure:
COUNTROWS('Enrollments')
and the pivot returns 64 for the same timeperiod. There is an active relationship to the calendar table in place.
Insight, please - I am getting tired of banging my head on this wall.
CALCULATE(SUM('Phone Data'[Outbound Call Count]))
This works equally well with email data.
I have another table for enrollments, and each row represents a single enrollment. Knowing that the total number of rows with a creation date in February, 2013 is 573, I measure:
COUNTROWS('Enrollments')
and the pivot returns 64 for the same timeperiod. There is an active relationship to the calendar table in place.
Insight, please - I am getting tired of banging my head on this wall.
