Sum of revenues by one country and the rest of the world

[Tendo]

Hi everybody,

please I need your help or at least some hints to solve my problem.

I would like sum revenues by one country , e.g. Germany, the rest of the world.

Example:

	Revenues	Revenue share
Germany	20 Mio. €	20%
Rest of the world	80 Mio. €	80%
Sum	100Mio. €	100%

Is it possible to get it with just one measure?

I am thankfull for every help I can get! 🙂

Have good weekend and stay safe!

Tendo

[amitchandak · Accepted solution]

@Tendo , if you create a new column

if([country] = "Germany" , [Country] , "Rest of the world")

else you have two create 3 measures, like

Sum(Table[Revenue])

calculate(Sum(Table[Revenue]), filter(Table,[country] = "Germany" ))

calculate(Sum(Table[Revenue]), filter(Table,[country] <> "Germany" ))

[Tendo]

HI @amitchandak ,

thanks a lot for your help!

I got another questions maybe you can answer it.

Is the CAse- Statement (PL SQL) not working in the sql query of PowerBI? I used DAX IF function to get what I needed. The question is just for my information.

Tendo