cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
atari35 Frequent Visitor
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. 

 

AmountsCount
Between 1 and 100005
Between 10001 and 200006
Between 20001 and 300004
Above 300002
1 ACCEPTED SOLUTION

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

 

View solution in original post

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

 

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

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

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

Power Platform World Tour

Find out where you can attend!

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