DAX - value of suppliers by band

[Anonymous]

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

[Anonymous]

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

Cheers

[amitchandak · Accepted solution]

@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