Value range buckets for summarized count view

[tomekm]

Hello,

I'm trying to create buckets for specific value ranges, but I want to show them in a summarized table, so that for the 4 distinct buckets below I can show the count of the individual POs that fall within that range:

PO number	PO value	Bucket
123	49000	0-50k
789	21000	0-50k
211	79000	0-50k
333	550000	>500k
456	51000	50-100k
222	234000	100-500k
543	1600000	>500k

Desired output:

Buckets:	Count of POs
0-50k	3
50-100k	1
100-500k	1
>500k	2

Thank you.

[amitchandak · Accepted solution]

@tomekm , This requires segmentation using the independent table.

Please refer if my video or link can help

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k