Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 , 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" ))
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
76 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |