Matrix with Quantity of buyers that buy certain quantity of products from transactions table

[ladislaocsulak]

Having a table with sales and buyers. Is there a way to create a matrix that indicates in the rows the quantity of purchases per user and in the values ​​the number of users who purchased that quantity of products?

For example:

Quantity of purchases Quantity of buyers

                1                               4

                2                               3

               ….                              ....

That would mean that there were 4 buyers who made 1 purchase and 3 buyers who made 2 purchases.

I upload a Power Bi with a dummy source table similar to what I am using:

https://drive.google.com/drive/folders/1TOYezhAuiy0ADTNcKVL1ayNw5XoLMo_I?usp=share_link

Thanks in advance!

[amitchandak]

@ladislaocsulak , I think Dynamic segmentation can help

 Dynamic segmentation  Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ