DAX Fridays! #20: Parent and Child Functions -Hierarchies 

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!!! 😎😎😱😱😱😱😱😱💪🏼💪🏼

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

Awesome!

Thank you so much for all DAX files

Thank you very much Ruth !! This video helped me in solving one my long outstanding issue with org hierarchical slicer

Thank you!

Very useful to solve complex buiness problem, thanks!

great thanks

Very useful

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!

Very nice

Nice one ruth

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 👍🏻👍🏻👍🏻 🎉👍🏻

You are my PowerBI Guruvu(Teacher).

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.

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.

Ruth, it's amazing. Just want to know, how can we implement security on these hierarchical things.

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?

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.

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

For practicing purpose want to get the excel which you'd used here. Where to get the excel?

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?

Thanks Ruth, how can we apply this to a 4 level hierarchy?

Hi Ruth, How can i find out the sum of number of Child iD's per Parent ID?

I am not able to download the excel file. I want to use it for practice.

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.

What about component has duplicate mean multiple parent hierarchy..

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!

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 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..

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!

Can you please explain as how to use this relationship in Viz and show some meaningful presentations

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): ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-q8WDUAiTGeU.html 2) Create Hierarchies in Power Query: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oEOaqyaZTZw.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!