Need help grouping filtered columns into numeric ranges

[Anonymous]

I have a table showing:

and I want to be able to filter in my report by contractor and get the sum of the rows like below: 

and I would like to put these into buckets of ranges like below:

So far, I've created a table (not sure if this is correct):

but I'm having trouble with the next steps.

This was the closest guide I could find but it does not work form. Not sure if it is correct: https://www.burningsuit.co.uk/blog/dax-how-group-measures-numeric-ranges

thank you

[ryan_mayu]

@Anonymous 

pls check if this is what you want

[Anonymous]

It should be 8 results for 1-5 and 2 results for 5-10. Sorry for my typo, it should say 10 not 100.

[ryan_mayu]

i didn't copy paste all your data since it's a screenshot. you can try my solution on your own data.

[Anonymous]

apologies, i didn't see the attached pbix file. I tried to use it in my own data but it did not sum up the totals per contractor, and instead shows one total in one range.

each contractor line only shows a value of of one, but there are multiple rows for each contractor. i need it to sum each of the contractors value's and then bucket them into the ranges. do i just use a simple sum equation?

[ryan_mayu]

you can try this

Measure 2 = sumx('Table (2)',[Measure])

[Anonymous]

sorry for the late reply, that does not work either.