Forum Discussion
Dynamic Categorization of data based on measures
Thank you both so much, hopefully this link should work.
I added a table entitled Expected, which simply summarizes the main table and adds the measures stated above. Then added an expected sheet for how the expected result should work. This would of course work for my real dataset, however based on what filters the user selects the lowest unit price may change, thus using a static intermediary table wouldn't work. I've tried that table as a variable within the measures but just couldn't get it to work.
One last note, the first table on the expected sheet will be a graph on the final report, but as i'm sure you know using measures for your axis labels is a whole other item. I have that piece working fine in the final solution so for simplicity I kept this pbix to the root issue.
https://drive.google.com/file/d/1JopKLP6A6TWiQhjUH3_uno6qtoGA0j0g/view?usp=sharing
I have still not understood your requirement. Someone else will help you.