Boolean Measure Filter

[BSM1985]

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.

[ryan_mayu]

@BSM1985 

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

[BSM1985]

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 · Accepted solution]

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