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 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.

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

3 Replies

    • 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