Filter error to exclude blanks

Question

Hi Experts&nbsp;I cannot see the error here in my DAX' the filter filter is correct when I want to count the values and exclude blanks from second column I get an error..&nbsp;Non MS Apps. = CALCULATE(COUNT(JohnH_SPO_EUCPriorityListAllDiv[Count]),FILTER(JohnH_SPO_EUCPriorityListAllDiv,JohnH_SPO_EUCPriorityListAllDiv[Microsoft or Not] = "Retain" || FILTER(JohnH_SPO_EUCPriorityListAllDiv,JohnH_SPO_EUCPriorityListAllDiv[Risk Based Criteria] &lt;&gt; BLANK())))

vanessafvg · Accepted Answer

should you not use &amp;&amp; rather than ||?&nbsp; what&nbsp; error are you getting
Non&nbsp;MS&nbsp;Apps.&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;COUNT&nbsp;(&nbsp;JohnH_SPO_EUCPriorityListAllDiv[Count]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JohnH_SPO_EUCPriorityListAllDiv,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JohnH_SPO_EUCPriorityListAllDiv[Microsoft&nbsp;or&nbsp;Not]&nbsp;=&nbsp;"Retain"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;JohnH_SPO_EUCPriorityListAllDiv[Risk&nbsp;Based&nbsp;Criteria]&nbsp;&lt;&gt;&nbsp;BLANK&nbsp;()&nbsp;&nbsp;&nbsp;&nbsp;))

Forum Discussion

Filter error to exclude blanks

2 Replies

Related content

RANKX excluding blanks

Filters: Exclude Numbers

How to exclude blanks from decomposition tree?

Exclude blank data from calculations

RankX Excluding Blanks