Display Child records if associated to a Parent in a Separate Table

[imranami]

This is a separate question which is related a thread answered here.

Is there a way to achieve the following:

What I am trying to achieve is to allow a user to select any Name with a Status of Away, then display a list of Parents with an Away status in a seperate table. Once a user selects a Parent from that table, another seperate table should display all Names associated to that Parent, irrespective of their own Status.

I have included a link to the file if that helps:

OneDrive link

Best regardsm

ImranAmi

[kentyler]

This may not be exactly what you were looking for, but perhaps it will give you some ideas

I split your data into a fact table and a dimension table and added those tables back to the model 

i was then able to create a splitter based on the parent status field of the parent table

when you select in that splitter you only the parents that have that status

when you select a parent you get their children

splitting the data into 2 tables that were related together was the key to being able to filter it without having to write a lot of DAX measures. This follows the Slogan 1 for working in Power BI, Fix your data first. https://bislogans.com/3-shape-your-business-data-before-you-load-it-into-power-bi/

[imranami]

Thank you Ken this helps.

The first step is needed - a user should be able to select an Away status from the first Table in order to display a list of Parent names with that status in a separate table (and then proceed with the following steps laid out in my example).

The query editor is disabled in this scenario because we are currently using a push dataset. Is there a way to recreate this functionality in DAX?

[kentyler]

I think we are misunderstanding each other somewhere. Would you like to do a screen share to straighten it out. I can start a zoom session and send you a link ? or you can do so, as we will be looking at your screen and send to me. ken@8thfold.com

[imranami]

Thanks Ken. I have just sent an invite via Zoom.