Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
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
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.
Works great! Thanks
@Anonymous
I create a new table to sum up the order number.
Table 4 = SUMMARIZE('Sheet21',Sheet21[order],"Number",COUNT(Sheet21[order]))
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")
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |