Forum Discussion

ErickTilieri's avatar
ErickTilieri
Regular Visitor
4 years ago

Calculated measure in Filter function not working

Hello,   I'm having trouble understanding why my filter expression is not working. The syntax bellow uses a calculated measure named LOST, as well as the subsequent measures that I'm using.   N...
technolog's avatar
technolog
Icon for Super User rankSuper User
4 years ago

You need to create Lost like a calculated column in you case

Lost = IF(sales_data_sample[inactive] = "inactive", "lost", if(sales_data_sample[AVG order per month] >= 0.33, "not lost", "lost"))
  • ErickTilieri's avatar
    ErickTilieri
    Regular Visitor
    4 years ago

    Sorry, forgot to mention that the [inactive] measure was also a calculated measure and not a calculated column.
    Same for AVG order per Month.
    So since all those measures are not calcualted column, I don't think your suggestion would work.