Calculate based on Measure with boolean filter

[JonasBI]

Hi everyone,

I came across a problem today. 

This is my current measure:

CALCULATE(
         [Measure],
                FILTER(
                     [Table1],
                     (Table1[Column1] <> 0 && Table1[Column1] <> 100) &&
                     Table1[Column2] <> FALSE() &&
                     Table1[Column3] = "active"
               )
)

The measure gives me this error

Table1[Column2] <> FALSE() with this expression I am trying to filter on all but the Trues (so including blanks)

Can anyone tell me how to adjust my Measure so that it works?

Thanks in advance!

[alosada · Accepted solution]

Hello,

For the calculate measure it's not necessary to put filter into it, as it already understands that  has to filter and expression. Try this instead:

CALCULATE(
         [Measure],
                     Table1[Column1] <> 0, Table1[Column1] <> 100,
                     Table1[Column2] <> FALSE() ,
                     Table1[Column3] = "active"
)

[JonasBI]

CALCULATE(
         [Measure],
                     Table1[Column1] <> 0, Table1[Column1] <> 100,
                     Table1[Column2] <> TRUE() ,
                     Table1[Column3] = "active"
)

this worked fine, thank you! 🙂