Splitting measure into categories for filtering

[Federicofkt]

Hi, I'd like to split a measure into 3 categories to use them as a filter, like so:

=if([% utilizzo fine mese]>1 or [% utilizzo fine mese] = '>100%','>100%',
if([% utilizzo fine mese]>0.85,'>85%', '<85%'
)
)

this code is working perfectly fine for the background colors of the column "% utilizzo fine mese" (where instead of the strings there are the colours), but for some reasons is not working when used as a filter selection.

The code is giving no errors, but when I try to use it, only the '<85%' appears and it doesn't work. I can click on it but it's not selected as a filter.

Thanks!

[F_B]

I'm sorry but filter panes only accept dimensions, not measures.

You might need a different way to achieve your goal, like creating a new field in load editor to flag [% utilizzo fine mese] with the desired options.

Hope this can be helpful

[rwunderlich]

To create a filter, you will need to add an Aggr()

=Aggr(
if([% utilizzo fine mese]>1 or [% utilizzo fine mese] = '>100%','>100%',
if([% utilizzo fine mese]>0.85,'>85%', '<85%'
)),
[% utilizzo fine mese])

-Rob