Forum Discussion

atari35's avatar
atari35
Frequent Visitor
7 years ago
Solved

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
Need Help
  • AlB's avatar
    AlB
    7 years ago

    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

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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