How to use SUM and SUMX in Power BI // Complete Beginners Guide to Power BI in 2020

Подписаться 46 тыс.

Просмотров 18 тыс.

50% 1

In this video I touch on some of the basic DAX expressions and how you can use them in your Power BI Reports.
Introduction: (0:00)
What is DAX: (0:31)
SUM: (1:03)
SUMX: (2:17)
Microsoft Docs: (4:07)
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@harshalpatil2111 Месяц назад

Thank god you are there... :)👍

@zauronasaurtv6240 3 года назад

Thank you so much sir!

@SolutionsAbroad 3 года назад

You're welcome, thanks for watching!

@TheBestBirdBomber 2 месяца назад

Is there a way to fix the row totals when using SUM and IF conditions together?

@todayflower6367 2 года назад

very nice video!

@giri41 2 года назад

Please continue making videos.. thanks

@BISAACk 2 месяца назад

Hi, i tried the SUMX but when i added the new measure to the visual table it did not like it. Total Avg = SUMX(MeasureTable, MeasureTable[Field01] + MeasureTable[Field03] + MeasureTable[Field03]) / 3 Basically i wanted to sum 3 columns and get the average total

@LintuMan1004 Год назад

Nice 👍

@giri41 4 месяца назад

please help below code not working .. bypassing IF statement when i use in SUMX

@erwerwewerwer4575 Год назад

Legend!

@giri41 2 года назад

How to count customer hierarchy in customer table spending in each category in material table

@antipghosh 2 года назад

Sir, How to do summation of first 3 numbers in a series in power bi....? Series: {5, 7, 2,3,9,10,2} Desired sum: 5+7+2

@ltsMeEvy2 3 года назад

So does this mean I use SUM on a already existing colum, and SUMX to calculate data from a non existing colum, or does this logic not always apply? Thank you so much for the video!

@SolutionsAbroad 3 года назад

SUM and SUMX both use existing columns, either directly or through expressions, The expressions could be more calculations but ultimately they always refer to a column in a table I've never used SUM or SUMX other than this way, hope that helps!

@shruthishree5785 3 года назад

Good explanation.. Please upload more vedios on pwrbi dax

@SolutionsAbroad 3 года назад

More videos are coming buddy, thanks for watching!

@gilang6128 3 года назад

please upload more videos especially common function DAX like count, sum, divide, filter, cumulative, if/switch

@SolutionsAbroad 3 года назад

Hi, thanks for watching! I already covered a lot of the functions you've mentioned, let me know if there's any specific function you want me to cover!

@kamrankhan-hh9jv Год назад

i have been stuck somewhere total in correct in measure kindly solve this issue can i sent to my PBXfile

@pthapa55 10 месяцев назад

what are you stuck on, send an example.

@giri41 4 месяца назад

please help. this is not working.. Test_1 = var PriceperUnit_CY = DIVIDE([Sales_CY],[Quantity_CY],0) var PriceperUnit_PY = DIVIDE([Sales_PY],[Quantity_PY],0) var SalesVariance = [Sales_CY]-[Sales_PY] return SUMX(VALUES(ATC[material_style1]),if(DIVIDE([Sales_CY],[Quantity_CY],0)=0 || DIVIDE([Sales_PY],[Quantity_PY],0)=0,[Sales_CY]-[Sales_PY],1))

@nehasharma-jd9kc 3 года назад

nice video but u should show your screen more closely, it really hard to see the formulas. ya one more thing, I m watching the playlist but I feel videos should be arranged according to topics means step by step not randomly

@SolutionsAbroad 3 года назад

That's great feedback thanks, I've fixed this issue in my recent videos, where i zoom in / out of the screen

@learnenglishwithcumaali2883 2 месяца назад

You did not explain the difference between SUM and SUMX???

@policani 2 года назад

Why the heck do I have to use Dax for this? In Excel, I just toggle my pivot tables between count and sum.

@SolutionsAbroad 2 года назад

Hi Cark, you can also do this by putting the values on a table, Power BI will calculate the sums for you. The point of using DAX is explicitly define what the calculation should do when someone else uses it

@giri41 4 месяца назад

Test_1 = var PriceperUnit_CY = DIVIDE([Sales_CY],[Quantity_CY],0) var PriceperUnit_PY = DIVIDE([Sales_PY],[Quantity_PY],0) var SalesVariance = [Sales_CY]-[Sales_PY] return SUMX(VALUES(ATC[material_style1]),if(DIVIDE([Sales_CY],[Quantity_CY],0)=0 || DIVIDE([Sales_PY],[Quantity_PY],0)=0,[Sales_CY]-[Sales_PY],1))