cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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

1 REPLY 1
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

## Helpful resources

Announcements

#### New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,021)