Forum Discussion
Solved
Counting 2 columns from the same table
I am trying to create a measure that counts the "Attended" from the Attendance column and the "Complete" from the Interview Status__C column. I have a formula that pulls in the "Attended" totals but...
maybe you can use something like this to count attended and complete
Measure = var _attended = COUNTX(FILTER('Campaign Member',
'Campaign Member'[Attendance] = "Attended"),1)var _complete =COUNTX(FILTER('Campaign Member', 'Campaign Member'[Interview_Status__c] = "Complete"),1)return _attended + _complete
Hi DataNinja777,
No, not always does a member attend and complete. So I want it to count Attended(which is a column that populates if a member attended a meeting) and Compete(which is a column that populates if a member completed an interview.
Hope that makes sense and thanks for your help!
maybe you can use something like this to count attended and complete
Measure = var _attended = COUNTX(FILTER('Campaign Member',
'Campaign Member'[Attendance] = "Attended"),
1
)
var _complete =
COUNTX(
FILTER(
'Campaign Member', 'Campaign Member'[Interview_Status__c] = "Complete"
),
1
)
return _attended + _complete
That worked perfectly.
Thank you!!!