DAX - Percent of Total vs Percent of Grand Total

In this video Mitchell discusses the difference of writing a Percent of Total calculation in DAX vs. using the default built-in capability that will return the Percent of Grand Total.

👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - https://pragmaticworks.com/pricing/

00:00 - Introduction to DAX
00:38 - Building a Custom DAX Measure for Percent of Total
01:10 - Modifying Filter Context for Total Sales Measure
02:10 - Creating a Variable to Capture Total Sales for All Countries
03:23 - Verifying Total Sales for All Countries with a New Measure
05:20 - Performing Division Calculation for Percent of Total Sales
06:23 - Using Built-In Power BI Functionality for Percent of Grand Total
07:30 - Comparing Results and Understanding the Difference between Percent of Total and Percent of Grand Total
8:30 - Conclusion Remarks
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5

🔗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-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter:   / pragmaticworks  
✔️Facebook:   / pragmaticworks  
✔️Instagram:   / pragmatic.works  
✔️LinkedIn:   / pragmaticworks  
✔️YouTube:    / pragmaticworks  


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks