SUMX with two filters

Question

Hi,&nbsp;Im getting the error 'The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.' for below. Could somebody please help?&nbsp;Count 1 = CALCULATE(SUMX(vw1, [Count]), vw1[checkdate] = 1 &amp;&amp; vw1[FinishedDate] = BLANK())&nbsp;Thanks&nbsp;Liam

pragati11 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Try the following:&nbsp;Count1 = CALCULATE ( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUMX(vm1, [Count]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER( &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; vm1, vm1[checkdate] = 1 &amp;&amp; vm1[FinishedDate] = BLANK( )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp;Please give a kudos if this is helpful or accept it as a solution if it works!&nbsp;Thanks,Pragati

Forum Discussion

SUMX with two filters

2 Replies

Related content

SumX

SUMX

SUMX and FILTER

SumX with multiple filters

DAX - SUMX with multiple filters.