Forum Discussion

BSM1985's avatar
BSM1985
Helper IV
5 years ago
Solved

Boolean Measure Filter

Hi Team,   I created a Measure with max and min functions to compare the data and the output of the measure is TRUE or FALSE. Now the requirement is to filter out the FALSE records. As per below o...
Need Help
  • BSM1985's avatar
    BSM1985
    5 years ago

    I created another column to fix this issue
    IF(BOOLEAN_MEASURE,1,0)

     

    I added this field in the filter to choose either 1 or 0

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

BSM1985 

have you tried to add the measure to filters and set to 'True'? Does that work?

  • BSM1985's avatar
    BSM1985
    Helper IV
    5 years ago

    Hi ryan_mayu ,

     

    I tried that, I have added the boolean measure to filters pane. But I could not open it to choose the boolean values. Its greyed out.

    • BSM1985's avatar
      BSM1985
      Helper IV
      5 years ago

      I created another column to fix this issue
      IF(BOOLEAN_MEASURE,1,0)

       

      I added this field in the filter to choose either 1 or 0