In this video Mitchell discusses the difference of writing a Percent of Total calculation in DAX vs. using the default builtin 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 OnDemand Learning classes to get an extra 30% off https://pragmaticworks.com/pricing/'>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 BuiltIn 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:
OnDemand Learning Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5
Pragmatic Works OnDemand Learning Packages: https://pragmaticworks.com/pricing/'>https://pragmaticworks.com/pricing/
Pragmatic Works Boot Camps: https://pragmaticworks.com/bootcamps/
Pragmatic Works Hackathons: https://pragmaticworks.com/privatetr...
Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtualme...
Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/privatetr...
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) 6385743
Email: [email protected]
#PragmaticWorks