Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
6 years ago
Solved

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...
  • jdbuchanan71's avatar
    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]
    )