Searching a way to create ranges, but to sum them before that

[bggs]

Hello PBI users, 

This days I am struggling to do the following in PBI:
I have this sort of data:

Region	City	Value (Items)
Europe	Manchester	11000
Europe	Manchester	15000
Europe	Manchester	30000
Europe	Munich	2000
Europe	Munich	1500
South America	Sao Pao	40000

The output that I need in a table "chart" in the Dashboard is:

Range	Region	City	SUM(Value)
50000-59999	Europe	Manchester	56000
Below 5000	Europe	Munich	3500
40000-49999	South America	Sao Pao	40000

After that I need a table "chart" in the Dashboard showing:

City	Below 5000	40000-49999	50000-59999	Grand TOTAL
Manchester			1	1
Munich	1			1
Sao Pao		1		1
TOTAL	1	1	1	3

Every help would be much appreciated! Thanks! 

[Idrissshatila]

Hello @bggs ,

You could acheive this by creating groups or bins.

Check this link for instructions https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin