cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

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

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

   

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


1 REPLY 1
Super User
Super User

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

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!