Creating Dynamic Bins based on Selected Fish

[nickhukriede]

I am attemping to create dynamic bins based on a selected fish in order to display a frequency distribution of lengths for that fish. For example, if the fish selected is "Bigmouth Buffalo", the four sizes are 18, 24, 30, and 37. The 5 bins would then be <18, 18-24, 24-30, 30-37, and 37+. These four values are different for each selected fish species. I want to be able to count how many fish of the selected species fall into each dynamically created bin. Any helpful DAX syntax would be greatly appreciated. 

Thanks

[amitchandak]

@nickhukriede , Refer to my video :https://www.youtube.com/watch?v=CuczXPj0N-k

and attached file after signature if that can help

[Fowmy]

@nickhukriede 

Please refer to this article from Reza Rad: https://radacad.com/dynamic-banding-or-grouping-in-power-bi-using-dax-measures-choose-the-size-of-bi...

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn