counta grouping

[atari35]

Hi,

I have a table with a column and values. I'm trying to group the values into group ranges. For exmple

Amounts
10000
5000
4000
2000
5
11000
12000
20000
15000
30000
100000
25000
80000
18000
21000
14000
23500

and im looking for an outcome like this. 

Amounts	Count
Between 1 and 10000	5
Between 10001 and 20000	6
Between 20001 and 30000	4
Above 30000	2

[AlB · Accepted solution]

Hi @atari35 

Probably the easiest is to create add a calculated column with the range:

Bucket =
SWITCH (
    TRUE (),
    Table1[Amount] <= 10000, "Between 1 and 10000",
    Table1[Amount] <= 20000, "Between 10001 and 20000",
    Table1[Amount] <= 30000, "Between 20001 and 30000",
    "Above 30000"
)

then use it in a matrix visual with a simple COUNT measure