Greater than and Less than - Set Analysis Expression using a Measure

[ca3868077]

Hello,

I'm trying to write a set analysis expression that counts the number of [Items] where the value of a measure [Fill %] is greater than 0 and less than 25.

I've written the formula several different ways, but no success, the results are incorrect:

Count({<[Fill %]={">0 <25"}>}Items)

Count({$<[Fill %] > {'0'}, [Fill %] < {'25'}>} Items)

Count({$<[Fill %] = {'>0'}, [Fill %] ={'<25'}>} Items)

None of the above work.  Any ideas or suggestions are greatly appreciated!

[Nixi80]

It seems ok. I checked a few rows, it works fine.

The problem was related to the Key, I just considered one field concatenated properly.

Thanks