You might encounter a requirement where you’ll need to display the ratio percentage of a particular level in your data against a parent level, and many might find this to be a tricky task as there is no straightforward function to achieve this result. In this video, Harsh is going to demonstrate how you can calculate percentages in hierarchical form.
***** Video Details *****
00:00 Introduction
01:14 The matrix
01:35 % of total sales
03:06 Total sales
04:08 Total sales per territory
04:44 Total sales per product
06:21 % of sales per territory
06:57 % of sales per product
08:12 Results
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial