DAX code for custom bin sizes

[Frenchtom811]

Hi folks - referring to the below screen grab, I am struggling with the DAX code necessary to creat custom bin sizes.  As you can see, I need bin sizes that are not consistent in size.  These bins need to show a count of Opportunity ID numbers that fit within each bin.  Each Opportunity ID has multiple revenue values that must be aggregated at the Opportunity ID level.  Any Idea how this might be done?

[amitchandak · Accepted solution]

@Frenchtom811 , you need to dynamic segementation using an independent table with bucket and use that in new measures .

refer : https://www.youtube.com/watch?v=CuczXPj0N-k

or

https://www.daxpatterns.com/dynamic-segmentation/
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

[Frenchtom811]

That did the trick @amitchandak .  Great video too!  Many thanks.