How To Calculate Percentages In A Hierarchical Form In Power BI

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

**** Related Links ****
How To Calculate Ranking In A Hierarchical Form -    • How To Calculate Ranking In A Hierarc...  
How To Calculate Ranking In A Tabular Form -    • How To Calculate Ranking In A Tabular...  

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-...
FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-form...
Enterprise DNA Membership - https://www.enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://www.enterprisedna.co/enterpri...

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial