Percentage

[gauravnarchal]

Hello  - I need help to create a measure to find out how much the “Transfer” sales % is from the total sales excluding the “Self” Product sales.

Table 1

ProductCode	Sales
78	-18545
3	-15545
27	-11910
28	-3790
30	-3435
47	-1095
48	-840
0	-680
1	-400
2	-350
36	0
45	50
46	120
60	160
61	180
63	280
64	320
77	330
84	360
85	450
8	490
58	500
59	520
98	544
99	550
78	580
3	660
27	690
28	705
30	710
47	730
48	750
0	760
1	810
2	820
36	845
45	885
46	890
60	895
61	910
63	1000
64	1030
77	1060
84	1065
85	1155
8	1240
58	1264
59	1370
98	1375
99	1460
78	1520
3	1565
27	1645
28	1680
30	1690
47	1695
48	1720
0	1735
1	1825
2	1840
36	1895
45	1935
46	1970
60	1996
61	2000
63	2035
64	2100
77	2135
84	2225
85	2255
8	2285
58	2295
59	2345
98	2505
99	2585
78	2610
3	2620
27	2665
28	2675
30	2735
47	2900
48	2910
0	2935
1	2985
2	3000
36	3065
45	3185
46	3330
60	3385
61	3425
63	3635
64	3705
77	3730
84	3870
85	4005
8	4525
58	4640
59	4785
98	4965
99	5100

Table 2

ProductCode	ProductCode
Transfer	78
Transfer	3
Transfer	27
Transfer	28
Transfer	30
Transfer	47
Transfer	48
Train	0
Train	1
Train	2
Car	36
Car	45
Car	46
Car	60
Car	61
Car	63
Car	64
Car	77
Car	84
Car	85
Car Transfer	8
Self	58
Self	59
Self	98
Self	99

[parry2k]

@gauravnarchal try this measure:

Total Sales = SUM ( Table1[Sales] )

Transfer Sales = CALCULATE ( [Total Sales], Table2[Product] = "Transfer" )

Total Sales without Self = CALCULATE ( [Total Sales], Table2[Product] <> "Self" )

Transfer % = DIVIDE ( [Transfer Sales], [Total Sales without Self] )

, you can always do this in one measure.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[gauravnarchal]

@parry2k  - Thanks your suggestion is working for me.

How can I exclude "Train" & "Self" from the total sales instead of only "Self"?