Rebuild Excel Measures in Powerbi

[lboldrino]

Hi. i try to rebuild a excel in powerBI.

Country	Sales Target	Budget
DE	198 313 800	211 151 483
AT	59 737 000	60 895 812
CH	30 227 467	29 684 932
IT	73 839 000	88 879 020
FR	25 172 000	25 187 918
ES	11 070 560	11 159 557
NL	15 420 000	15 742 907
BE	9 209 000	9 392 804
UK	8 339 904	8 514 919
TR	5 416 160	4 509 283
SE	28 106 865	29 359 101
FI	3 735 380	3 901 801
DK	17 591 002	17 790 188
NO	1 489 256	1 506 120
CZ	16 885 183	17 223 386
SK	6 253 699	6 378 958
PL	7 073 139	8 302 920
RU	7 520 170	6 590 888
US	59 887 207	59 079 975
CA	16 188 281	16 462 609
BR	3 620 442	3 726 906
CN	75 585 163	77 170 899
TW	1 920 806	1 961 103
IN	20 307 530	20 736 483
KR	12 223 519	12 749 150
SG	4 358 709	4 312 913
JP	8 403 105	8 579 031
Direct Sales	13 849 401	14 118 060
BA	7 727 115	7 877 010
ZZZ		-37 955 687

i need to create 3 new columns:

Country	Sales Target	Budget	total sales	Anteil	total Budget
DE	198 313 800	211 151 483
AT	59 737 000	60 895 812
CH	30 227 467	29 684 932
IT	73 839 000	88 879 020
FR	25 172 000	25 187 918
ES	11 070 560	11 159 557
NL	15 420 000	15 742 907
BE	9 209 000	9 392 804
UK	8 339 904	8 514 919
TR	5 416 160	4 509 283
SE	28 106 865	29 359 101	31 842 244	88%	33 260 902		Total sales = SE+ FI	Anteil = SE /TotalSales
FI	3 735 380	3 901 801		12%	33 260 902			Anteil = FI /TotalSales
DK	17 591 002	17 790 188	19 080 259	92%	19 296 307		Total sales =DK + NO	Anteil = DK /TotalSales
NO	1 489 256	1 506 120		8%	19 296 307			Anteil =NO /TotalSales
CZ	16 885 183	17 223 386	23 138 881	73%	23 602 343		Total sales = CZ + SK	Anteil = CZI /TotalSales
SK	6 253 699	6 378 958		27%	23 602 343			Anteil = SK /TotalSales
PL	7 073 139	8 302 920
RU	7 520 170	6 590 888
US	59 887 207	59 079 975
CA	16 188 281	16 462 609
BR	3 620 442	3 726 906
CN	75 585 163	77 170 899	77 505 969	98%	79 132 002		Total sales = CN + TW	Anteil = CN /TotalSales
TW	1 920 806	1 961 103		2%	79 132 002			Anteil = TW /TotalSales
IN	20 307 530	20 736 483
KR	12 223 519	12 749 150
SG	4 358 709	4 312 913
JP	8 403 105	8 579 031
Direct Sales	13 849 401	14 118 060
BA	7 727 115	7 877 010
ZZZ		-37 955 687

any idea?

ThanX 🙂

[lbendlin]

You need to add a "Region"  column.

[lboldrino · 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])

)