Help with Value Range

[Anonymous]

Hi

I am new to Power BI and need help with the following.

I have 3 tables

1) Customer 

2) Region 

3) Sales  (12 months of sales history, multiple rows per customer)

I need to calculate the total sales per customer and then represent this in a value range.

For example

	<$25,000	>$25,000 <$50,000	>$50,000	Total
Region	#	$	#	$	#	$	#	$
North	5	65,000	8	328,000	6	413,400	19	806,400
East	8	91,200	12	321,600	2	160,400	22	573,200
West	15	120,000	11	360,800	9	524,700	35	1,005,500
South	4	72,000	15	592,500	1	65,000	20	729,500
Total	32	348,200	46	1,602,900	18	1,163,500	96	3,114,600

Any help would be appreciated 

Thank you

[parry2k · Accepted solution]

@Anonymous check this post for dynamic segmentation.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

You could refer to this blog:

https://powerpivotpro.com/2015/03/creating-a-histogram-with-a-user-defined-number-of-buckets/

Regards,

Lin

[parry2k · Accepted solution]

@Anonymous check this post for dynamic segmentation.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡