Power BI DAX Tutorial (5/50) - What is Sum and SumX

What is SUM Function in DAX Power BI , What is SUMX Function in DAX Power BI, What is the difference Between Sum or SUMX in DAX Power BI , When to use SumX function in DAX, when to use SUM function in Power BI. Power BI DAX Tutorial with Examples
#powerbi #powerbidax #sumx #sum
Datasource Link
drive.google.c...
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/...
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...

[@rameshs3219]

You are quite popular in Pune Sir!.. Btw, I from TN. The concepts u teach are crisp and neat. Great Efforts and Thank You So Much!.

[@AnalyticswithNags]

Thanks for letting us know. Keep learning. Share this channel with friends and colleagues

[@ajays8258]

thank you naganna miru mnc lo pani chestara or company lo as a trainer miru pani chestunara? chala manchi knowledge undi miku powerbi lo:)

[@AnalyticswithNags]

Thank you

[@somenghosh4163]

Thank for making such powerful knowledgeable and easy understanding video. Earlier i was finding the measure and calculate very complicated but going through this playlist of dax i am improvising on my BI knowledge. Once again thank you so much.

[@AnalyticswithNags]

Keep learning. Share this channel with friends and colleagues

[@somenghosh4163]

@@AnalyticswithNags Definitely

[@devender476]

SIR, sum and sumx working same in report while calculating total sales. But SUMX helps in finding sales amount when there is no calculated column (ex. (qty*sales)).Instead of creating new column we create measure SUMX to work row level which helps in improving performance, and reduces memory usage right. in simple words can we say sum works on column level and SUMX works in row level. if we asked this question in interview.

[@AnalyticswithNags]

Watch again again. You will get the answer

[@devender476]

Understood Sir, When we want to work with one coloumn we need to go for SUM, For multiple columns or row by row operations-SUMX

[@KhalidKhans55]

Thank you so much Sir for such nice demonstration, easily understandable with practical examples. This will make me learn alot from you and enhance speedy growth in my career. Stay Blessed

[@AnalyticswithNags]

You are most welcome

[@frustratedgaiii4088]

Sir , I used sumx function to calculate profit but the value is different ,I used the profit column that is showing profit 1.31m but by performing sumx function my profit is 1.27m 😅am I doing something wrong

[@AnalyticswithNags]

Data is different

[@akshayshirbhate7]

Sir, can we say that it will give result same as we create calculated column by product of unit price and qty column

[@AnalyticswithNags]

Watch again. Thanks keep learning share this channel with friends and colleagues

[@kishanbhise4733]

Best explanation of sumx and sum functions ,use of excel to explain this was simply best approach

[@AnalyticswithNags]

Thanks keep learning

[@studioboss849]

Hai sir today I started searching power bi related vedios you made explanation very simple sir thanks a lot for beautiful explanation sir

[@AnalyticswithNags]

Thanks and welcome

[@arunsundarm4566]

Thank you for good explanation

[@AnalyticswithNags]

Glad it was helpful!

[@siddheshdandagavhal9804]

1) SUMX: When u have to calculate row by row. ex: sum(sales, sales[unit price]*sales[QTY]) 2) SUM: When doesn't require row level operation.

[@prasannakumarreddy6410]

Brother it is not possible to use sumx function while creating a new column,i am not getting proper result while using sumx in creating new column

[@AnalyticswithNags]

In new column don’t use any function.. do with actual columns

[@prasannakumarreddy6410]

@@AnalyticswithNags ok thank you brother

[@vinipowerbi]

Amazing video.... It made so easy to understand thank you very much.

[@AnalyticswithNags]

Thanks keep learning

[@nizammohideen3763]

Thanks for the Video bro. Good Explanation and Keep rocking. Vera level neenga

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@9731893629]

Thanks bro …At last I understand with simple way of your explanation

[@AnalyticswithNags]

Thanks follow the channel to learn power bi with simple explanation

[@LaylaAlharbi-ze5oq]

7:13 can you please explain to me what you did here so the "Argunent" go away?

[@yashshrivastava1612]

Can we do sumx from two different tables?

[@AnalyticswithNags]

Need to use related function

[@dhavalasowbhagya6567]

Such a great magical voice u have...

[@AnalyticswithNags]

Welcome

[@mr.invincible8986]

what if we use "=sum([quantity]*[unit*price])

[@AnalyticswithNags]

Can you try and let me know

[@mr.invincible8986]

@@AnalyticswithNags Yes, it is working in MS office 2021, although I did not check in older versions.

[@ExcelWithChris]

Great explanation. Thanks from South Africa.

[@AnalyticswithNags]

Most welcome, Keep Learning

[@LaylaAlharbi-ze5oq]

Thank you so so much for this video

[@AnalyticswithNags]

You are so welcome!

[@alialbayati9368]

You made it really simple, Thanks for the tutorial.

[@AnalyticswithNags]

Glad it helped!, Share and subscribe to our channel.

[@Pappu_bhau_0]

You are the best teacher I have got till today Your voice is so clear, enthusiastic , energetic. Thankyou so much for clearing concepts

[@AnalyticswithNags]

Thanks keep learning

[@AnalyticswithNags]

Thanks keep learning

[@sandipansarkar9211]

finished watching

[@AnalyticswithNags]

Glad to help

[@captainsaver69]

Amazing explanation

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@DevarajuMohan]

thank you sir

[@AnalyticswithNags]

All the best

[@vanamojuumarani4305]

Super sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@shreyamukkawar2989]

Awesome!

[@AnalyticswithNags]

Thank you! Cheers!

[@reddiranisanapa2262]

please send data set for practicing purpose

[@AnalyticswithNags]

Check the description

[@asuresh2541]

Where i can get those presentation ppt.

[@AnalyticswithNags]

we dont share the ppt