Forum Discussion
Calculate based on Measure with boolean filter
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!
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"
)
2 Replies
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"
)