You are an excellent teacher and I am inspired to forward my knowledge like you. Thank you for all your hard work, time and selflessness and sharing your invaluable knowledge. It means a lot. xxx
Ruth I like this one. Any chance of you showing how to put the PATHCONTAINS together with a filter like you did with the Top N? I'm thinking of org structure, it'd be nice to see how you could select a person in an org and see everyone who rolls up to them.
You just solved a particular problem. I have been trying to work out a way to iterate down through boms to find if software sits in a particular bom. This will work.
I may have drawn a blank Ruth. I will keep trying. My issue is that the Component are used in multiple Parents and the bom hierarchy has up to 6 levels. In short, what I am trying to do is to create a query that flags a Parent that has certain Software down any level in the hierarchy. I will keep trying unless you have a suggestions (like give up) :)
Curbal, I found a nice solution on BIAccountant blog from last year. Quite complex PQ with some trick M that iterates down the levels. Still stress testing but seems to work.
Hello Ruth ! This video is very interesting and I would like to ask you if you can make a follow up video with an example how to use this Dax expressions or to take this example further and to show us how to use this function more detailed ... And I'm looking forward today's Dax Friday 👍🏻👍🏻👍🏻 🎉👍🏻
Curbal hello Ruth, yes kind of but I'm afraid I'm not able to explain it properly in English. Could be cool if you can do a general example with the use of power bi filters and then I can ask my questions based on your cool video ! Thanks so much, appreciate it a lot 👍🏻👍🏻👍🏻
Hi Ruth! thank you for this video. I've followed every step and everything worked perfectly regarding the columns. However, when I go back to the visuals' pane, I do not see any hierarchy and therefore I cannot use it for creating drill-down visuals. Please help!
Hi Ruth! I think this solution here only works when you have just one parent per child. I need to do a Bill of materiales where there are many childs that are used on multiple parents (For example a model of screw -Child- that is used in lots of final products -Parents-, or the delivery box -We use the same one for multiple products-). If you do know how to do it, could you make a video about it? Thank you and thanks for this great channel!
Hi Ruth...You are excellent... your videos are very informative and unique I have a query...in Parent child Dax If we want to repeat emp key and Mgr key...then there is sn error. Issue is...that employee A is reporting to emp x.. But now he is reporting to Emp Z We want to keep both values. How can we solve this..
Hi Ruth, I have a file in which a column is in hierarchical format I want to spilt it into parent child format in different column.. How to do this any idea?
Hey Ruth, is it possible to view parent & child in same visual (no drilling) and the parent showing sum of all its children instead of only the selected children? For example, if i want to see the count of employees in Cities like London, Leeds, Birmingham and also in all of England and Europe in same visual with no drill down
112|23|18|1 As per my understanding when we use PATH function, 112 denotes the Org Lvl 1 and 23 denotes Org Lvl 2 and so on. Can this be bi-directional like below, 1|18|23|112 1 denotes last Org Lvl N and 18 denotes Org Lvl N-1 and so on. Basically I want to have Child-Parent Hierarchy. The reason he if one persons belongs to 2 difference regions how we can take care of this using PATH function. Basically what I need is Child-Parent relationship instead of Parent-Child relation ship.
Hi, you forgot to show the values associated with the hierarchy. Do you simply attach the values and it will just show the values in a collapsible manner?
Very good video! Thank you so much! Suggestion: It is not very easy to follow a data set that has computer-like values (MMK115/1). It would be better if the values were more human readable such as CEO, Vice President, Manager, Employee etc. for someone who does not even know what is a parent or child function. Other than that, thank you!
Hi Ruth, very clear and crisp explanation. I am working on developing a data warehouse on manufacturing process and was struggling to get real world example on product traceability. Whenever search for parent child hierarchy topic most of the time we come across organization kind, but this one I could relate very well. Thanks for that.
Hello, how do you use the DAX hierarchy in the report view? I've created a 4 level hierarchy using DAX and was expecting to be able to drag this into a report but it doesnt show in the report view.
Hello Ruth, Thank you for your awesome DAX Fridays! video series and other intermediate Power BI videos, keep them coming! I have a question regarding Hierarchy which I can't wrap my head around. Hopefully you, or anyone in the Power BI community, could help me understand this. I can see how powerful utilizing Hierarchy could help in modelling data better and providing a fast and efficient way of retrieving data with DAX. (Especially when dealing with BOM data sets) However, I have confusion over how hierarchy works over these 3 videos: 1) Creating and working with hierarchies in Power BI (3-11g): th-cam.com/video/q8WDUAiTGeU/w-d-xo.html 2) Create Hierarchies in Power Query: th-cam.com/video/oEOaqyaZTZw/w-d-xo.html 3) DAX Fridays! #20: Parent and Child Functions -Hierarchies: This Video. My confusions are: 1) Does all the above 3 videos provide the same outcome, just with different methods? If so, wouldn't (1) be a simpler form of creating hierarchy groups in Data Modeling and provide filtering capabilities when using the 'CALCULATE()' function? 2) How can I use any of these above methods, create a hierarchy data model, and utilize other DAX functions such as 'RELATED()', 'RELATEDTABLE()', 'USERELATIONSHIP()' etc. in the 'CALCULATE()' function filtering ability to calculate what I want? 3) Does it mean that having Hierarchies will eliminate my need to calculate certain results because of it's dynamic data drilling down abilities? Hope that I am phrasing my question in a fathomable way. Thank you very much for your wonderful work and I am eager to receive your response on this as it definitely will tremendously help me in my work to create data models which DAX functions will shine!
Thanks for taking the time to write such a detailed comment! My time to answer it is unfortunately a bit limited, but think of it like this, different scenarios will require different approaches and what the Power BI team does is giving us different tools to solve them. All methods are valid depending on your situation. For a more detailed answer, I encourage you to re-post this in the power bi community where others can also chip-in. Thanks again! /Ruth
You are an excellent teacher and I am inspired to forward my knowledge like you. Thank you for all your hard work, time and selflessness and sharing your invaluable knowledge. It means a lot. xxx
And thanks for your feedback!
/Ruth
Fico impressionado como um vídeo de 6 de jan. de 2017 não perde sua importância com o tempo. Sempre Estou reaprendendo com vc. Valeu!!! 😎😎😱😱😱😱😱😱💪🏼💪🏼
🥳🥳
Thank you so much for all DAX files
My pleasure!
Ruth I like this one. Any chance of you showing how to put the PATHCONTAINS together with a filter like you did with the Top N? I'm thinking of org structure, it'd be nice to see how you could select a person in an org and see everyone who rolls up to them.
Great idea, noted ;)
Happy new year!
/Ruth
Thank you very much Ruth !! This video helped me in solving one my long outstanding issue with org hierarchical slicer
Wonderful to hear :)
Very useful to solve complex buiness problem, thanks!
+Lixia Zhang Hi Lucia! Glad you found it useful and thanks for the feedback!
/Ruth
You just solved a particular problem. I have been trying to work out a way to iterate down through boms to find if software sits in a particular bom. This will work.
Yey! Glad it was useful :)
/Ruth
I may have drawn a blank Ruth. I will keep trying. My issue is that the Component are used in multiple Parents and the bom hierarchy has up to 6 levels. In short, what I am trying to do is to create a query that flags a Parent that has certain Software down any level in the hierarchy. I will keep trying unless you have a suggestions (like give up) :)
Have you tried asking in the power bi community? Post some sample data too!
/Ruth
Curbal, I found a nice solution on BIAccountant blog from last year. Quite complex PQ with some trick M that iterates down the levels. Still stress testing but seems to work.
Excellent and Thanks for sharing :)
/Ruth
You are my PowerBI Guruvu(Teacher).
Hello Ruth ! This video is very interesting and I would like to ask you if you can make a follow up video with an example how to use this Dax expressions or to take this example further and to show us how to use this function more detailed ...
And I'm looking forward today's Dax Friday 👍🏻👍🏻👍🏻
🎉👍🏻
+SmartBimson Hi Absolutely, is there any specific scenario you had in mind?
/Ruth
Curbal hello Ruth, yes kind of but I'm afraid I'm not able to explain it properly in English. Could be cool if you can do a general example with the use of power bi filters and then I can ask my questions based on your cool video ! Thanks so much, appreciate it a lot 👍🏻👍🏻👍🏻
+SmartBimson ok, it will take some weeks as I have other videos schedule but as soon as I can I will make it for you! :)
/Ruth
Curbal that's so cool !!! Can't wait anymore already 😉🍾 have a great weekend Ruth !
+SmartBimson The same to you and many thanks for watching and supporting my videos! You are the best! 😊
/Ruth
Hi Ruth! thank you for this video. I've followed every step and everything worked perfectly regarding the columns. However, when I go back to the visuals' pane, I do not see any hierarchy and therefore I cannot use it for creating drill-down visuals. Please help!
Hi Ruth! I think this solution here only works when you have just one parent per child. I need to do a Bill of materiales where there are many childs that are used on multiple parents (For example a model of screw -Child- that is used in lots of final products -Parents-, or the delivery box -We use the same one for multiple products-). If you do know how to do it, could you make a video about it? Thank you and thanks for this great channel!
Yes, please let me know if you have a solution for child items having multiple parents....currently results in an #ERROR
Did you find a solution?
hello, the example link was inaccessible , could you please check? Thanks for your great video
Hi Ruth...You are excellent... your videos are very informative and unique
I have a query...in Parent child Dax
If we want to repeat emp key and Mgr key...then there is sn error.
Issue is...that employee A is reporting to emp x..
But now he is reporting to Emp Z
We want to keep both values.
How can we solve this..
Hi Ruth, I have a file in which a column is in hierarchical format I want to spilt it into parent child format in different column.. How to do this any idea?
I am not able to download the excel file. I want to use it for practice.
Nice one ruth
+RRR program Thanks ;)
/Ruth
Hey Ruth, is it possible to view parent & child in same visual (no drilling) and the parent showing sum of all its children instead of only the selected children? For example, if i want to see the count of employees in Cities like London, Leeds, Birmingham and also in all of England and Europe in same visual with no drill down
Try using the matrix visual with the stepped option on (or off can’t remember which)
/Ruth
112|23|18|1
As per my understanding when we use PATH function, 112 denotes the Org Lvl 1 and 23 denotes Org Lvl 2 and so on.
Can this be bi-directional like below,
1|18|23|112
1 denotes last Org Lvl N and 18 denotes Org Lvl N-1 and so on. Basically I want to have Child-Parent Hierarchy. The reason he if one persons belongs to 2 difference regions how we can take care of this using PATH function.
Basically what I need is Child-Parent relationship instead of Parent-Child relation ship.
Hi, you forgot to show the values associated with the hierarchy. Do you simply attach the values and it will just show the values in a collapsible manner?
What about component has duplicate mean multiple parent hierarchy..
For practicing purpose want to get the excel which you'd used here. Where to get the excel?
+Ak S Hi, you can find it in the description box.
/Ruth
Very good video! Thank you so much!
Suggestion: It is not very easy to follow a data set that has computer-like values (MMK115/1). It would be better if the values were more human readable such as CEO, Vice President, Manager, Employee etc. for someone who does not even know what is a parent or child function.
Other than that, thank you!
+Brendan Crowther Ah, true! Thanks for the feedback, I will take it into account for next videos :)
/Ruth
Hi Ruth, very clear and crisp explanation. I am working on developing a data warehouse on manufacturing process and was struggling to get real world example on product traceability. Whenever search for parent child hierarchy topic most of the time we come across organization kind, but this one I could relate very well. Thanks for that.
Perfect! Happy it worked for you :)
/Ruth
Hi Ruth,
How can i find out the sum of number of Child iD's per Parent ID?
+sharvan hameed Hi!
Let me do a Dax Friday video of it!
/Ruth
hi Ruth, thanks for the video. Would you be able to share the PBI file. For some reason I am unable to download the file from the link you shared.
Oh, it is probably broken. I will fix it tomorrow!
/Ruth
Thanks
It is working, can you please try again?
/ruth
Thank you!
Hello, how do you use the DAX hierarchy in the report view? I've created a 4 level hierarchy using DAX and was expecting to be able to drag this into a report but it doesnt show in the report view.
Best way to get support is to contact the power bi community (community.powerbi.com). Make sure you post as much info as possible.
/Ruth
Awesome!
Very useful
Can you please explain as how to use this relationship in Viz and show some meaningful presentations
Ruth, it's amazing. Just want to know, how can we implement security on these hierarchical things.
Mmmm that is a question for the Power Bi Community. Make sure you post as many details as possible of your data and model.
/Ruth
Very nice
+Asim Abdul Wahab Thanks and Happy Friday :)
/Ruth
Thanks Ruth, how can we apply this to a 4 level hierarchy?
You should, but post the details of your case in the Power bi Community (Community.powerbi.com) to get detailed help.
/Ruth
great thanks
Hello Ruth,
Thank you for your awesome DAX Fridays! video series and other intermediate Power BI videos, keep them coming!
I have a question regarding Hierarchy which I can't wrap my head around. Hopefully you, or anyone in the Power BI community, could help me understand this.
I can see how powerful utilizing Hierarchy could help in modelling data better and providing a fast and efficient way of retrieving data with DAX. (Especially when dealing with BOM data sets)
However, I have confusion over how hierarchy works over these 3 videos:
1) Creating and working with hierarchies in Power BI (3-11g): th-cam.com/video/q8WDUAiTGeU/w-d-xo.html
2) Create Hierarchies in Power Query: th-cam.com/video/oEOaqyaZTZw/w-d-xo.html
3) DAX Fridays! #20: Parent and Child Functions -Hierarchies: This Video.
My confusions are:
1) Does all the above 3 videos provide the same outcome, just with different methods? If so, wouldn't (1) be a simpler form of creating hierarchy groups in Data Modeling and provide filtering capabilities when using the 'CALCULATE()' function?
2) How can I use any of these above methods, create a hierarchy data model, and utilize other DAX functions such as 'RELATED()', 'RELATEDTABLE()', 'USERELATIONSHIP()' etc. in the 'CALCULATE()' function filtering ability to calculate what I want?
3) Does it mean that having Hierarchies will eliminate my need to calculate certain results because of it's dynamic data drilling down abilities?
Hope that I am phrasing my question in a fathomable way. Thank you very much for your wonderful work and I am eager to receive your response on this as it definitely will tremendously help me in my work to create data models which DAX functions will shine!
Thanks for taking the time to write such a detailed comment!
My time to answer it is unfortunately a bit limited, but think of it like this, different scenarios will require different approaches and what the Power BI team does is giving us different tools to solve them.
All methods are valid depending on your situation.
For a more detailed answer, I encourage you to re-post this in the power bi community where others can also chip-in.
Thanks again!
/Ruth
Thank you Ruth for taking your time to reply my queries. I will take this up to the community. 😁
The pleasure is all mine :)
/Ruth