Put orders into buckets based on total sales

[Anonymous]

Is it possible to count how many orders are in different ranges ( 1-49, 50-59, 60-69, etc.)? I have a sales table that has mutple lines per order so it would need to sum up each order based on order number.

[Greg_Deckler]

Yes, sample data would help and it might be as simple as a column formula that employs SUMX/COUNTX, FILTER, ALL and EARLIER. Tough to say exactly. For something a little more complex: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-ABC-Classification/m-p/479146

[Anonymous]

I think the process would be go sum each order using the order number coloumn then counting how many are within a range of dollars. Then repeat that for each bucket.

here is a sample file: https://www.dropbox.com/s/9vqui3xkhd21yt1/sample.xlsx?dl=0

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.  This uses 2 calculated columns and therefore will not work with filters/slicers.

Hope this helps.

[Anonymous]

Works great! Thanks 

[ryan_mayu]

@Anonymous

I create a new table to sum up the order number.

Table 4 = SUMMARIZE('Sheet21',Sheet21[order],"Number",COUNT(Sheet21[order]))

Then create a column to assign the orders to corresponding range.

range = SWITCH(TRUE(),'Table 4'[Number]<3,"1-3",'Table 4'[Number]<5,"3-5",'Table 4'[Number]<10,"5-10",'Table 4'[Number]<20,"10-20")

Please let me know if I understand your request correclty.Thanks