Measure returning TRUE/FALSE not valid as visual level filter?

[AlB]

Hi all,

I have a measure that returns TRUE or FALSE to indicate what lines  want to show in a matrix visual. I want to use the measure in the visual level filters. I place it there with no problem but then the system does not let me select what items to show. It seems like that option is not active. If I update the measure to return 1 and 0 instead, I can use it as visual level filter with no problem, selecting what items to show. If the measure returns text I have no problems either.

Is this a limitation? Can measures that return TRUE, FALSE, i.e. a boolean, NOT be used as visual filters?

Many thanks

[Greg_Deckler · Accepted solution]

@AlB - That's correct, I have run into this a few times and have generally ended up using 1 and 0 for true and false.