Bucketing with decimals/percents

[Anonymous]

I wrote:

The format is a percentage.

To bucket, I wrote:

The combination of the above shows all values in my table as "0-2.5%". A successful measure would accurately indicate that 8.2% Vacancy in the bucket of "7.6% - 10%"

Any thoughts? 

[amitchandak]

@Anonymous , Keep all them only <=

example

Switch ( True(),

[measure] <=2.5 , "1",

[measure] <=5.0 , "2",

[measure] <=7.5 , "3"

// and so on

)

https://www.youtube.com/watch?v=CuczXPj0N-k