cancel
Showing results for
Did you mean:
Visitor

## How to group data into buckets with a measure

Is it possible to group data into price buckets without using a calculated column?

I have a list of prices and I'd like to write a measure that indicates what "price bucket" they fall in.

I've tried :

Price Bucket:=Calculate( LASTNONBLANK(VALUES(Price_Bucket[Price_Bucket]), 1), FILTER(Weekly_Trades, [Pricet]<= [Price Bucket Max] && [Pricet]>[Price Bucket Min]))

Price Bucket Min:=MIN(Price_Bucket[Min])

Price Bucket Max:=MAX(Price_Bucket[Max])

But as you can see, it only identifies the price bucket if the price equals the max for the price bucket range.

Microsoft

## Re: How to group data into buckets with a measure

Hi @kbtmk,

When you use the formulas your given to get the max and min Price Bucket, which should be persistent. And and there is only one max value and one min value, how do you group the price to different groups?

```Price Bucket Min:=MIN(Price_Bucket[Min])
Price Bucket Max:=MAX(Price_Bucket[Max])```

Based on your description, I am unable to reproduce your scenario, could you please share 'Price_Bucket' and 'Weekly_Trades' sample data for futher analysis.

In addition, calculate different groups, if is used in calcuculated column.  If you want to create a measure, rether than calculated column, you can use values function in measure. For instance, I have the following sample data.

Create a measure, create a table, select the [Client_ID] and measure as value level, please see the result shown in screenshot below.

`Group-list = IF(VALUES(Table1[Client_ID])=5,"Yes","No")`

Best Regards,
Angelia

Announcements