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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
gauravnarchal
Post Prodigy
Post Prodigy

Percentage

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

 

ProductCodeSales
78-18545
3-15545
27-11910
28-3790
30-3435
47-1095
48-840
0-680
1-400
2-350
360
4550
46120
60160
61180
63280
64320
77330
84360
85450
8490
58500
59520
98544
99550
78580
3660
27690
28705
30710
47730
48750
0760
1810
2820
36845
45885
46890
60895
61910
631000
641030
771060
841065
851155
81240
581264
591370
981375
991460
781520
31565
271645
281680
301690
471695
481720
01735
11825
21840
361895
451935
461970
601996
612000
632035
642100
772135
842225
852255
82285
582295
592345
982505
992585
782610
32620
272665
282675
302735
472900
482910
02935
12985
23000
363065
453185
463330
603385
613425
633635
643705
773730
843870
854005
84525
584640
594785
984965
995100

 

Table 2

 

ProductCodeProductCode
Transfer78
Transfer3
Transfer27
Transfer28
Transfer30
Transfer47
Transfer48
Train0
Train1
Train2
Car36
Car45
Car46
Car60
Car61
Car63
Car64
Car77
Car84
Car85
Car Transfer8
Self58
Self59
Self98
Self99
2 REPLIES 2
parry2k
Super User
Super User

@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 YouTube.gif 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.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k  - Thanks your suggestion is working for me.

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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