How to fix Incorrect Totals in Power BI → th-cam.com/video/yw0QHu9V4UQ/w-d-xo.htmlsi=Or8h_GwkJGQWCIQ6 📘 Grab your copy today → goodly.co.in/power-query-book/ ↗️Check out my courses on Power BI → goodly.co.in/learn-dax-powerbi/
It is incorrect to call these totals incorrect. It is important to know, what the result is and why it is. You normally cannot add up averages, like average price in a year is not sum of months. And weighted average is not the same as average of averages. Same is with Max. Also, your correct totals function gives out crap, if you really make a new visual which does not have months and years, but only years. Plus is it really good to write a measure for just a specific matrix chart? Total is not the same as Sum. It should be ready as "for the whole category", which here is year. Complaining aside, you have taught a lot of good stuff, thanks.
This is so much helpful to undertand the base concepts...Thank you so much... and looking for more videos related to Dax. Also your book is excellent, enjoy reading it and trying out those...❤🙂
Excellent topic. DAX documentation is very poor compared to other languages. Definitions especially via a vis a function's genus, differentia and precise examples (Per Aristotle 2500 years ago). Your 'Access to rows' is an nice way to characterize measures
I hear him just fine. TH-cam has this issue. Exit the video and re-enter. Restart the app if that doesn't work. Happens to me at various times on various channels.
How to fix Incorrect Totals in Power BI → th-cam.com/video/yw0QHu9V4UQ/w-d-xo.htmlsi=Or8h_GwkJGQWCIQ6
📘 Grab your copy today → goodly.co.in/power-query-book/
↗️Check out my courses on Power BI → goodly.co.in/learn-dax-powerbi/
It is incorrect to call these totals incorrect. It is important to know, what the result is and why it is. You normally cannot add up averages, like average price in a year is not sum of months. And weighted average is not the same as average of averages. Same is with Max. Also, your correct totals function gives out crap, if you really make a new visual which does not have months and years, but only years. Plus is it really good to write a measure for just a specific matrix chart? Total is not the same as Sum. It should be ready as "for the whole category", which here is year. Complaining aside, you have taught a lot of good stuff, thanks.
If that was video by SQLBI we should had 60 mins video with pretty much no actual examples but tons of theory. Thank you for the great video Chandeep!
This is so much helpful to undertand the base concepts...Thank you so much... and looking for more videos related to Dax. Also your book is excellent, enjoy reading it and trying out those...❤🙂
This is so insightful, Thanks 😃
Amazing Sir.
Impressed your way of explaining and with gud examples.
I want to learn and interested in joining course.
Insightful.. thanks for sharing 🎉
Seus vídeos @GoodlyChandeep são ótimos!!!! Parabéns!
You r genius 🙏
This is so good
Thank for this video 😊
Great Video thanks!!
Great video. Thank you for sharing!!!!
Awesome 😎
Brilliant!!
Can you make the same video with Power Query functions classification?
sure can do
Brilliant!
What are the benefits of using dax formulas over the m language?
Thanks chandeep
Can we have the hard copy of the book?
I am trying to get it on Amazon asap
excellent
bought my copy too
Can I buy the book on Amazon to qualify for the virtual gift?
yes sir.. do it before 7th Feb
The formating of your total sales col looks a bit weird?
that's the Indian Comma Format
@GoodlyChandeep how does it work?
Excellent topic. DAX documentation is very poor compared to other languages. Definitions especially via a vis a function's genus, differentia and precise examples (Per Aristotle 2500 years ago). Your 'Access to rows' is an nice way to characterize measures
No voice can be heard...
I hear him just fine. TH-cam has this issue. Exit the video and re-enter. Restart the app if that doesn't work. Happens to me at various times on various channels.
man.. you gave me a heart attack there !
@@GoodlyChandeep All good on my end XD
Awesome video Chandeep!