Forum Discussion
Counting 2 columns from the same table
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
Super UserHi Crazypad
It sounds like your "Attended" field is a subset of "Complete" field, and everyone who "Attended" has "Completed" interview. Is this correct?
Replacing double ampersand ("&&") with double pipe ("||") counts "Complete" without double counting "Attended". Is this what you want?
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 + _completeThat worked perfectly.
Thank you!!!