Forum Discussion
Value range buckets for summarized count view
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.
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
1 Reply
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k