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 Ranki...
How To Calculate Ranking In A Tabular Form - • How To Calculate Ranki...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterpri...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterpri...
FREE - Power BI Resources - www.enterprised...
FREE - 60 Page DAX Reference Guide Download - www.enterprise...
Enterprise DNA Membership - www.enterprise...
Enterprise DNA Online - portal.enterpri...
Enterprise DNA Events - www.enterprise...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial
Негізгі бет How To Calculate Percentages In A Hierarchical Form In Power BI
No video
Пікірлер: 42