Dax to subgroup a coverage volume

[fbostan1]

I need help with getting Sub_Vol Column into subgroup 

For example : 0-50,000, 50,001-150,000, 150,001-250,000

So I could build a visual like this:

Thanks for the help!

[Ashish_Mathur]

Hi,

I'd like to try.  Share the download link of the PBI file.  Also, share the download link of an MS Excel workbook, showing the exact result.  If i can write the DAX measure for it, I should be able to tally my answer with yours that you will share in the Excel file.

[amitchandak · Accepted solution]

@fbostan1 , Create columns using Switch

Amount Bucket =  Switch( True() ,

[Amount] <50000, "    0 -50000",

[Amount] <100000, "  50000-100000",

//Add others

)

Same way you can create for Age

Either have space before bucket name to sort to create another column with same logic. To be used as sort column

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c