SUM vs SUMX in Power BI Which One Reigns Supreme for Data Analysis? | DAX

[@KSRDatavizon]

Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our UA-cam channel 👉Please ping on WhatsApp wa.me/9916961234

[@hendrag1174]

Again, this is a great video from KSR, thank you and keep up the good work. God bless.

[@KSRDatavizon]

Thanks, you too!

[@shreekantgosavi4726]

This is the best explanation

[@KSRDatavizon]

Thank You !

[@vishalichoppala2296]

It was very clear and clean. Thank you so much

[@KSRDatavizon]

You’re welcome 😊, Thank you, Please subscribe our channel for regular updates , all the best

[@noblesegs]

grx lesson watching from Nigeria

[@KSRDatavizon]

Thanks for watching, Thank you so much, please subscribe our channnel for regular updates and it motivates us a lot

[@manjupreetham]

Explanation is great 😊 we can understand easily the sum and sumx in bi

[@KSRDatavizon]

Thanks and welcome

[@karthikklp108]

Your videos lot help for me thank you 😊

[@KSRDatavizon]

My pleasure 😊

[@dilipinamdar5523]

Thank you so much

[@KSRDatavizon]

You're most welcome, You are welcome! Please subscribe our channel, it motivates us

[@b.sivakumarreddy1526]

Plz do more n more videos on real time projects which includes complex dax functions

[@KSRDatavizon]

sure

[@nareshchepuri84]

Awesome explaintion

[@KSRDatavizon]

Thanks and Welcome

[@kishork6405]

You are great sir

[@KSRDatavizon]

Thank you

[@anilpothuru5651]

Good one bro.
Keep do more....

[@KSRDatavizon]

Thank you, We will upload more. Keep watching

[@galiveetiprakash7453]

Excellent explanation bro

[@KSRDatavizon]

Thank you so much Prakash.

[@bharath554-y2f]

Sir can we concatenate both text and numeric value together in expression in sumx function

[@KSRDatavizon]

Hi Bharath! Yes, you can concatenate both text and numeric values in DAX, but it's important to note that SUMX is primarily used for summing numeric values. If you want to concatenate the result of a SUMX calculation with text, you can do it like this:
DAX
Copy code
TotalSalesWithText =
"Total Sales: " & FORMAT(SUMX(Sales, Sales[Amount]), "#,##0")
In this example, SUMX calculates the total sales, and then you concatenate it with the text "Total Sales: ". If you need more help or examples, feel free to ask!

[@nareshchepuri84]

Please do the video all important dax expression video also

[@KSRDatavizon]

Hi Naresh, Thank you for reaching us, your check our channel for all DAX videos which was already uploaded.

[@arunkumardhuttargi1490]

Please do all DAX expressions sir . Also Upload kannada Tutorial also .

[@KSRDatavizon]

Sure we will upload soon

[@ashokpatcha]

Is there a place we can download the source files from please?

[@KSRDatavizon]

yes, its available in Description, please check and can use for your practice

[@ashokpatcha]

@@KSRDatavizon I'm sorry, I don't see the source files anywhere in the Description of this video. Am I looking in a wrong description? Please help. Thank you.

[@MMMMM-nr7xe]

Pls do an video real time project sir.

[@KSRDatavizon]

Hi, We will shortly upload the real time project video.- Thank You...!

[@arunkumargandhe]

Can you also explain pros and cons of Sum and Sumx as sumx calculates runtime does it takes much time to display the results??

[@KSRDatavizon]

sumx takes more time, as it is iterator function