SUMX with two filters

[Anonymous]

Hi,

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?

Count 1 =

CALCULATE(

SUMX(vw1, [Count]), vw1[checkdate] = 1

&& vw1[FinishedDate] = BLANK())

Thanks

Liam

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Try the following:

Count1 = CALCULATE (

                                      SUMX(vm1, [Count]),

                                      FILTER(

                                                  vm1, vm1[checkdate] = 1 && vm1[FinishedDate] = BLANK( )

                                                 )

                                    )

Please give a kudos if this is helpful or accept it as a solution if it works!

Thanks,

Pragati

[Anonymous]

Thankyou 🙂