Forum Discussion
DAX code for custom bin sizes
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?
Anonymous , 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
2 Replies
Anonymous , 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-visualizationThat did the trick amitchandak . Great video too! Many thanks.