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

Pirce_buckets.pngPrice_List.png

I've tried : 

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

 

Where pricet:=Pricet:=MAX(Weekly_Trades[PRICE])

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. 

1 REPLY 1
Microsoft v-huizhn-msft
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. 

1.PNG

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")


 2.PNG

Please post more details, I think more information on the way your data is structured would help. Thanks a lot.

Best Regards,
Angelia

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)