Forum Discussion
Anonymous
3 years agoNot applicable
Need help grouping filtered columns into numeric ranges
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...
Anonymous
3 years agoNot applicable
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
Super User
3 years agoyou can try this
Measure 2 = sumx('Table (2)',[Measure])
- Anonymous3 years agoNot applicable
sorry for the late reply, that does not work either.