Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lboldrino
Resolver I
Resolver I

Rebuild Excel Measures in Powerbi

Hi. i try to rebuild a excel in powerBI.

 

 

CountrySales TargetBudget
DE198 313 800211 151 483
AT59 737 00060 895 812
CH30 227 46729 684 932
IT73 839 00088 879 020
FR25 172 00025 187 918
ES11 070 56011 159 557
NL15 420 00015 742 907
BE9 209 0009 392 804
UK8 339 9048 514 919
TR5 416 1604 509 283
SE28 106 86529 359 101
FI3 735 3803 901 801
DK17 591 00217 790 188
NO1 489 2561 506 120
CZ16 885 18317 223 386
SK6 253 6996 378 958
PL7 073 1398 302 920
RU7 520 1706 590 888
US59 887 20759 079 975
CA16 188 28116 462 609
BR3 620 4423 726 906
CN75 585 16377 170 899
TW1 920 8061 961 103
IN20 307 53020 736 483
KR12 223 51912 749 150
SG4 358 7094 312 913
JP8 403 1058 579 031
Direct Sales13 849 40114 118 060
BA7 727 1157 877 010
ZZZ -37 955 687
   

 

 

i need to create 3 new columns:

CountrySales TargetBudgettotal salesAnteiltotal Budget  
DE198 313 800211 151 483      
AT59 737 00060 895 812      
CH30 227 46729 684 932      
IT73 839 00088 879 020      
FR25 172 00025 187 918      
ES11 070 56011 159 557      
NL15 420 00015 742 907      
BE9 209 0009 392 804      
UK8 339 9048 514 919      
TR5 416 1604 509 283      
SE28 106 86529 359 10131 842 24488%33 260 902 Total sales = SE+ FIAnteil = SE /TotalSales
FI3 735 3803 901 801 12%33 260 902  Anteil = FI /TotalSales
DK17 591 00217 790 18819 080 25992%19 296 307 Total sales =DK + NOAnteil = DK /TotalSales
NO1 489 2561 506 120 8%19 296 307  Anteil =NO /TotalSales
CZ16 885 18317 223 38623 138 88173%23 602 343 Total sales = CZ + SKAnteil = CZI /TotalSales
SK6 253 6996 378 958 27%23 602 343  Anteil = SK /TotalSales
PL7 073 1398 302 920      
RU7 520 1706 590 888      
US59 887 20759 079 975      
CA16 188 28116 462 609      
BR3 620 4423 726 906      
CN75 585 16377 170 89977 505 96998%79 132 002 Total sales = CN + TWAnteil = CN /TotalSales
TW1 920 8061 961 103 2%79 132 002  Anteil = TW /TotalSales
IN20 307 53020 736 483      
KR12 223 51912 749 150      
SG4 358 7094 312 913      
JP8 403 1058 579 031      
Direct Sales13 849 40114 118 060      
BA7 727 1157 877 010      
ZZZ -37 955 687      

any idea?

ThanX 🙂

1 ACCEPTED SOLUTION

Solution: 🙂
 
TotalSales EUR =
GROUPBY(
FILTER (
'Sales Target',
'Sales Target'[Region] <> BLANK ()
),
    'Sales Target'[Region],
    'Sales Target'[Country],
    "Total Sales EUR",sumx( CURRENTGROUP(), 'Sales Target'[Sales Target EUR])
)

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

You need to add a "Region"  column.

Solution: 🙂
 
TotalSales EUR =
GROUPBY(
FILTER (
'Sales Target',
'Sales Target'[Region] <> BLANK ()
),
    'Sales Target'[Region],
    'Sales Target'[Country],
    "Total Sales EUR",sumx( CURRENTGROUP(), 'Sales Target'[Sales Target EUR])
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.