Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculate based on Measure with boolean filter

Hi everyone,   I came across a problem today.    This is my current measure: CALCULATE(          [Measure],                 FILTER(                      [Table1],                      (Tab...
Need Help
  • alosada's avatar
    alosada
    3 years ago

    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"
    )

alosada's avatar
alosada
Frequent Visitor
3 years ago

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"
)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

this worked fine, thank you! 🙂