Forum Discussion
michael_knight
6 years agoPost Prodigy
Count X Filter Help
Hi, I'm having problems with one of my measures. Total Disqualifed - 3rd party - No Spam & Duplicates = COUNTX(FILTER('Lead',( 'Lead'[Disqualified Reason] = "Cannot Contact" ||
'Lead'[Disqu...
- 6 years ago
Hello michael_knight
I think it is the && conditions stacking on each other filtering out all reults. GIve this a try:
Total Disqualifed - 3rd party - No Spam & Duplicates = COUNTX ( FILTER ( 'Lead', 'Lead'[Disqualified Reason] IN ( { "Cannot Contact", "Not Interested", "Wrong Number" } ) && 'Lead'[Enquiry Source] IN ( { "Facebook", "Email Campaign", "Twitter" } ) && 'Lead'[statecode] = 2 ), [statecode] )
v-juanli-msft
6 years agoCommunity Support
Is this problem sloved?
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please let me know.
Best Regards
Maggie