How To Calculate Ranking In A Hierarchical Form

[@EnterpriseDNA]

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

[@travishausler3677]

This was exactly what i needed.

[@mudassirsyedrashidali9787]

Wow Harsh. This is crazy good. Hats off and keep them coming.

[@harshjoshi3210]

Thank You so, so much, Moo Moo for your kind words of appreciation.🙂 I’m glad that you liked this content. Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Thanks for the support, Mudassir!

[@QasimAli-gy3nb]

Clear, crisp and concise explanation.

[@harshjoshi3210]

Thank You, @Qasim for you kind words of appreciation. I’m glad that you find it helpful in your learning curve!🙂 Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Hi Qasim, 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]

Thanks you Harsh for your thorough explanation. You made a really hard subject so easy to understand. I really enjoyed watching it and learn a lot.

[@harshjoshi3210]

You’re Welcome, @Hossein!!!🙂 I’m so glad that you liked the content and was able to contribute a little towards your learning process. Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Thanks for the support, Hossein!

[@rajeshthevar1522]

Great Explanation Harsh. Thankyou

[@harshjoshi3210]

You’re Welcome, @Rajesh!!!🙂

[@EnterpriseDNA]

Hi Rajesh, 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!

[@albertcampillo]

Another great tutorial Harsh, great work!

[@harshjoshi3210]

Thank You so much, @Albert for your kind words of appreciation!!!🙂

[@EnterpriseDNA]

Hi Albert, 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!

[@archstand]

Brilliant video ! Cheers from an Enterprise DNA Pro member

[@JoseAntonio-te7th]

Hi Harsh, A spectacularly explained video with very valuable information. Thank you very much

[@harshjoshi3210]

Hello @Jose, You’re Welcome!!!🙂 I’m so glad that you found this content so helpful. Stay tuned for more contents like this! Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Hi Jose, 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!

[@RehanShaikh-ip9hh]

Very good explanation. Thanks 👍

[@harshjoshi3210]

You’re Welcome, Rehan!!!🙂 Stay tuned for more contents coming up on Enterprise DNA by subscribing to the channel. Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Hi Rehan, 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!

[@nseworld5521]

Thanks guys, nice vid 🙌

[@EnterpriseDNA]

Hi, 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!

[@arbazahmad7177]

Excellent 🎉 thanks for sharing

[@myexcelacademy69]

Thank you, this helped me solve my issue. Exactly what I was looking for👍

[@santoshsrivastava31]

Superb...!,,

[@kassiowifried]

Good job

[@EnterpriseDNA]

Hi Kassio, 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!

[@kassiowifried]

@@EnterpriseDNA ok

[@3danim8r1]

Thanks Nice Explanation, In a same Matrix if we have to show top 5 customers (in those customers we have to show all products) in each Territory. How do we show that?

[@EnterpriseDNA]

Hey Nitin, It's a bit difficult to assess and give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on 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. Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

[@pratikghimire3938]

Great Video Harsh and Enterprise DNA Team, I was wondering , can we apply same concept to calculate % of total in Hierarchy , Thanks

[@harshjoshi3210]

Hello @Pratik, You’re Welcome!🙂 The link of the video pertaining to your question is already provided under the description section under the Related Links. Hoping you find it helpful and meets your requirements that you have been looking for. Thanks and Warm Regards, Harsh

[@EnterpriseDNA]

Hi Pratik, 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. Hope Harsh was able to answer you question. Cheers!

[@jxxxpxxx4484]

Hello Harsh, great to find clear explanation how to rank on different levels! Thank you. I wonder if you could help me with my issue while ranking my data. I have three levels of hierarchy say Branch, Product and Date. I have a slicer which selects a product and I want to see ranking within each branch based on sales. So far so good. The problem arises when I introduce a date range which is DIFFERENT for each branch. So, I have a new product which is launched on different dates in each branch (this day is set by a passing a condition but that doesn't seem to create a problem). I want to know the ranking in each branch in the first week after launch. When I use a manual date range via slicer, all works well. But when I try to pass the date via a measure I get the error message about providing 'a table where a single value was expected' or the wrong ranking (I have not managed to pinpoint in which case it would be the correct ranking as there are to many combination to go through manually). My thinking is that I need to tell my measure only to use the Branch on row where the rank is being calculated (I am using a table visual) but not sure how to do that (CALCULATE did not solve this). I'd be grateful for any ideas please! Thanks a lot, Jana

[@EnterpriseDNA]

Hello Jxxx Pxxx, 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/

[@manuelaguilar3523]

Hello Harsh. Thank you so much for this valuable information you gave us. It was an incredible video tutorial. But if my hierarchical form is year, month, and date, then how does the measure work? It is not working properly on months and dates. I don´t know what does it happen.

[@susantadas8213]

Great explanation undoubtedly, though I have something to ask you. Instead of all rank If I want to use TOP N slicer inside the same measure. My approach was, used Top N inside Rankx in your measure that mentioned in the video( Rankx(TopN(selectedvalue..), ,) like this pattern using my current measure. But no luck to be honest. Good to have some insights about it.

[@EnterpriseDNA]

Hello Susanta Das, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. 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/

[@abhimalhotra-t4e]

please share the pbix for me its not working with column

[@EnterpriseDNA]

Hi Abhi, all pbix file/datasets/resource files are available for download in the Enterprise DNA On-Demand platform, which is accessible via a Subscription. Check out the link below. Cheers! Sign up here: app.enterprisedna.co/sign-up

[@shoaibrehman9988]

Hi, i hv product and qty, first i hv ranked the products by simple count of that product, highest count with Rank 1 then so on measures working fine. Now i want some of top rank 3 products Quantities by a dax measures. I am unable to achieve pls assist.