DAX Fridays! #3: SUM and SUMX

Dax Fridays! Today we will go through: how to use SUM() and SUMX(), the difference between them and when should we use one vs the other. The DAX SUM function calculates the sum of all numbers in a column while the DAX SUMX function returns the sum of an expression for each row in a table. 02:28 Create a measure to calculate the total sales using SUMX function 03:40 Create a calculated column for total sales (row by row) 05:16 Create a measure to calculate the total sales using SUM function 06:00 Difference between SUM and SUMX Link to Curbal Glossary: https://curbal.com/blog/glossary/SUM-dax PREVIOUS VIDEO: https://www.youtube.com/watch?v=kC3w_KVVabY NEXT VIDEO: https://www.youtube.com/watch?v=V8wYTjKyvgk For this you need the Northwind dataset: https://www.youtube.com/watch?v=k3NMIlLffrU or you can download our example HERE: https://curbal.com/blog/glossary/sum-dax https://curbal.com/blog/glossary/sumx-dax Keynotes: Northwind datasource 01:44 SUMX 02:39 SUM 04:45 Calculated column vs measure 06:44 Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB ► Linkedin: https://goo.gl/3VW6Ky #DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP