Need help grouping filtered columns into numeric ranges

Question

I have a table showing:&nbsp;and I want to be able to filter in my report by contractor and get the sum of the rows like below:&nbsp;&nbsp;&nbsp;and I would like to put these into buckets of ranges like below:&nbsp;&nbsp;&nbsp;So far, I've created a table (not sure if this is correct):&nbsp;but I'm having trouble with the next steps.&nbsp;This was the closest guide I could find but it does not work form. Not sure if it is correct:&nbsp;https://www.burningsuit.co.uk/blog/dax-how-group-measures-numeric-ranges&nbsp;thank you&nbsp;&nbsp;

ryan_mayu · Answer

Anonymous&nbsp;
pls check if this is what you want

anonymous · Answer

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 · Answer

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

anonymous · Answer

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?&nbsp;

ryan_mayu · Answer

you can try this

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

Forum Discussion

Need help grouping filtered columns into numeric ranges

6 Replies

Related content

Page Level filter for different groups

Grouping rows by Column and then updating Column

Create columns group

Grouping Columns

Matrix column not grouped