Forum Discussion

BSM1985's avatar
BSM1985
Icon for Helper IV rankHelper IV
6 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 output, I would like to see only TRUE records and remove the FALSE records from the view.

 

Will be possible to add the filter in filters pane and choose TRUE, this is what the users expectation is.

  • 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

3 Replies

  • BSM1985 

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

    • BSM1985's avatar
      BSM1985
      Icon for Helper IV rankHelper IV

      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
        Icon for Helper IV rankHelper IV

        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