How to Filter the child records based on the parent records in query editor?

[PowerBITesting]

I have account and contact with 1:N relation. I have added filter in Account as if account is Active. But I need to filter/load the contact if the account is associtiated is active/loaded  or  not? 

is this possible to filter in query editor or do we need to filter by using report level filter?

[v-lionel-msft · Accepted solution]

Hi @PowerBITesting ,

Is your table like this?

Try to do add filters in 'Edit query'.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PowerBITesting , I think it needs to done at report level 

but refer

https://www.thebiccountant.com/2019/10/03/parent-child-hierarchies-with-multiple-parents-in-power-bi...

https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.