How to do special aggregation with IF case in matrix?

[Anonymous]

I have a matrix and a basic numeric measure.

In my matrix I have Rows:

• Continent,
• country,
• city,
• street.

I want to have a special aggregation...

• For street level I want to show the value as it is.
• For city level, I want (sum of street) , but to show only if the value is negative. (otherwise show 0)
• For all above levels, I just want to sum whatever is in city level.

That is:

example 1

example 2

[Greg_Deckler]

@Anonymous Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community