cancel
Showing results for
Did you mean:
Highlighted
atari35 Frequent Visitor

## counta grouping

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
1 ACCEPTED SOLUTION

Accepted Solutions Super User

## Re: counta grouping

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 Super User

## Re: counta grouping

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

Announcements   