cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

 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
2 REPLIES 2
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.

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.

Post Prodigy

@parry2k  - Thanks your suggestion is working for me.

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors