Filter out data in a measure without using the FILTER expression

Question

Hello,&nbsp;I have written a measure that distinct counts customers if they have positive Sales data:&nbsp;Customer Count =CALCULATE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DISTINCTCOUNT(&nbsp;Customer[Customer ID]&nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FILTER(&nbsp;SalesTable&nbsp;,&nbsp;[NetSales]&nbsp;&gt;&nbsp;0&nbsp;))&nbsp;--NetSales is a measure that simply sums up the Net SalesThis measure gives me the correct information but it tends to exceed the available resources in a matrix visual.Is there a way to rewrite this measure by not using the FILTER expression in order to improve performance?&nbsp;Thank you in advance.

amitchandak · Accepted Answer

Kristian_nho , Try like
&nbsp;
CALCULATE(Countx(filter( values( Customer[Customer ID] ), [NetSales] &gt; 0 ),[Customer ID]))

Forum Discussion

Filter out data in a measure without using the FILTER expression

2 Replies

Related content

Help!!! Expression Error

Regular expression

GROUP BY expression as a measure

Expression Error

Expression Evaluate , error