ISINSCOPE and HASONEVALUE Functions in DAX and Power BI Desktop

In this video we look at working with totals in DAX and being able to identify the total row with the ISINSCOPE, HASONEVALUE and ISFILTERED functions. I previously wrote a series of blogs on working with total rows that you can find on my website here: https://mitchellpearson.com/2018/05/18/unexpected-totals-in-dax-part-1/ If you enjoy this video and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell20" to receive a discount at check out when purchasing On-Demand Learning classes from https://pragmaticworks.com/pricing/ #PragmaticWorks #MitchellPearson #MitchellSQL - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning Courses FREE Trial: https://www.pragmaticworkstraining.com/on-demand-learning-free-trial/ 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 413-1911 Email: [email protected]