topic DAX - value of suppliers by band in DAX Commands and Tips

DAX - value of suppliers by band

Anonymous — Wed, 24 Aug 2022 09:39:34 GMT

Hello,

I have data with 800+ suppliers as below which I want to group into irregular banding.

So far I have set up the following table:

And added the following new measure

Which gives me this

What I want though is a total value in the last column based on the banding so it will show the total value of spend for all suppliers between MinValueRange and MaxValueRange for example total value of spend with suppliers between £10,000 to £25,000.

Any suggesions on how I can achieve this?

Thank you

Re: DAX - value of suppliers by band

amitchandak — Wed, 24 Aug 2022 10:13:36 GMT

Anonymous , I think you are trying something similar, check for the correct code

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

Re: DAX - value of suppliers by band

Anonymous — Wed, 24 Aug 2022 13:56:28 GMT

amitchandak thanks for this I have managed to adapt it and get it to do what I want.

Cheers