How To Calculate Percentages In A Hierarchical Form In Power BI

[@EnterpriseDNA]

Check out our FREE courses: bit.ly/3N00AJw

[@lukeshmukeandladybailey8840]

I just received a query for this today, great timing for this Video and Thanks so much for sharing!!!

[@EnterpriseDNA]

Hi LukeSmuke & LadyBailey , Glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@harshjoshi3210]

Hello LukeSmuke & LadyBailey, Thank You so much for taking your precious time to provide your valuable feedback. I’m so glad to know that you found this video helpful and was able to apply it in your business scenario. Stay tuned for more updates!!! Thanks and Warm Regards, Harsh

[@albertcampillo]

Excellent explanations Harsh... clear & concise!

[@EnterpriseDNA]

Hi Albert C, Glad that you appreciated our content!

[@harshjoshi3210]

Hello Albert, Thank you so much for taking your precious time to provide your valuable feedback. I’m so happy to know that you enjoyed this content and liked the explanation process. Stay tuned for more updates!!! Thanks and Warm Regards, Harsh

[@lucianaaguiar2244]

Dude, you saved me! Perfect explanation, especially about the hierarchy in the end of the video!

[@EnterpriseDNA]

Hi Luciana, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@Kali-zj3wr]

thank you so much! so clearly explained and easy to follow!

[@EnterpriseDNA]

Hi Kali, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@hossein3945]

Thank you Harsh for the thorough exolanation 👌

[@harshjoshi3210]

Thank You @Hossein!!! I’m glad that you liked the content.👍🏻

[@EnterpriseDNA]

Thanks for the continued support, Hossein!

[@paulitalkowski6956]

Harsh! You are the best! Thanks a lot! I used Your instructions to adapt this to my modell. Thanks to Your precise explanation I was able to grasp the idea behind this formula.

[@BrianStettenbenz]

Great work, Harsh. I was able to use this tutorial and quickly apply to my dataset.

[@EnterpriseDNA]

Hi Brian, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@PedroCabraldaCamara]

Very good Harsh (weird format for total sales)

[@dharmendars8483]

I have posted a similar scenario in the EDNA forum and you answered that...Thanks Harsh...your explanations are awesome and slow this makes it easy for us to follow.. Can you please post more videos especially on table function like Addcolumns/ Summarize/Calculatetable the use cases of these functions

[@harshjoshi3210]

Hello Dharmendar, Thank you so much for taking your precious time to provide your valuable feedback. Since past few days, I’ve been doing research and going through case studies on those functions. So absolutely, video on this topics are in contention. It’s great to know that you found this video helpful. Stay tuned for further updates!!! Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Hello Dharmendar S, Thank you for question. We appreciate your time. We'll surely consider the topics you've suggested in our future contents. Make sure that you're subscribed to our KZbin channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@toliashka1]

thank you, helped with my job task

[@EnterpriseDNA]

Hi Толя, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@Curlinator3000]

Does it work the same way if you have more than 2 hierarchical levels? E.g. I got market, customer, product group and product as levels and if I just duplicate the variables and add the inscope sequences it doesn't give me the percentage of revenue on product group level but gives all products 100%.

[@LucaCavallo-k3z]

Hi, thanks for your video. It resolves my problem partially. I have column "month" in the matrix, but it does not work if I consider this column. How can we adapt your code if you have a month column in matrix? Thanks!

[@EnterpriseDNA]

Hi @user-xs6yi7hg1b, It's a bit difficult to assess and recommend without looking at the data structure, model and working of the PBIX file for reference. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@AkashYadav-rx2jc]

Could show that with chart ?

[@AlexandrePena-z2y]

Perfect!!!! Thank you

[@satishyvv1234]

How to show category wise % with subcategory %

[@Bhargav5152]

Thanks - I am going to try this going to category and subcategory level - I may have to go one more subcategory down. Does it change ALLSELECTED () for variables?

[@EnterpriseDNA]

Hello Bhargav5152, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@alrigotto]

Great!! Thank you!!!

[@hendrag1174]

Thanks for this great video. I am also enrolling your class at Udm... GBU..

[@EnterpriseDNA]

Hi @hendrag1174, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

[@jayminbhatt7581]

video is really helpfull.

[@EnterpriseDNA]

Hi Jaymin bhatt , Glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@harshjoshi3210]

Hello Jaymin, Thank you so much for taking your precious time to provide your valuable feedback. I’m so glad to know that you found this video helpful in your learning curve. Stay tuned for more updates!!! Thanks and Warm Regards, Harsh

[@julie_chen]

Awesome 😊 🎉

[@cesarsaldana3429]

harsh never leave Enterprise dna, you explain super well

[@EnterpriseDNA]

Hi Cesar, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@mohammedabdulwahab4152]

Awesomes video about Hierarchical Form, I have similar Hierarchical form of Income statements, First row item is total sold quantity(sales volume) and then the Revenue(3 sub Product), Cost of Sale(5 sub line), Gp, Direct cost element(10 sub line), operating expenses(sub line 10) then Net profit, I need to divided all Main and subline item with sales volume to figure out the Rate per unit, Since my industry is readymix i have 10 location, can you help me with writing Measure, Thanking you in advance

[@shadowitself]

cool examplificationof how DAX is....peculiar :D with clear explanation why ;) however I believe there must be more universal way to tackle such problems thanks:)

[@EnterpriseDNA]

Hi Lukasz, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!