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 ...
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

     

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