Segment by sum of quantity and number of customers per segment

[Anonymous]

Hi Experts,

I have a fact table looking like this:

Orders

date                                                            customerid                       qty

27-02-2019	2	1
27-02-2019	2	6
27-02-2019	3	4
27-02-2019	3	2
27-02-2019	3	4
10-03-2019	1	6
10-03-2019	1	2
10-03-2019	3	2
10-03-2019	1	1

I would like to segment into quantity segments, showing number of customers in each segment. The segments are by quantity and result should like below:

Quantity segment                                                       February                  March

Quantity 1	1	1
Quantity 2	0	2
Quantity 3	0	0
Quantity 4	2	0
Quantity 5 or more!	1	1

The date columns february and march are showing number of customers per segment.

I've been looking at https://www.daxpatterns.com/static-segmentation/ and https://www.daxpatterns.com/dynamic-segmentation/ for inspiration - but I can't seem to get around a way of doing it. Any hints, help or advice to what DAX pattern is correct would highly appreciated.

I should hope to end up with a visual like the one below:

Best wishes and hope - from:

Jon