Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
pls check if this is what you want
Proud to be a Super User!
It should be 8 results for 1-5 and 2 results for 5-10. Sorry for my typo, it should say 10 not 100.
i didn't copy paste all your data since it's a screenshot. you can try my solution on your own data.
Proud to be a Super User!
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?
you can try this
Proud to be a Super User!
sorry for the late reply, that does not work either.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |