Forum Discussion

twitchingdog's avatar
twitchingdog
New Member
6 years ago

Power BI Query: Identify Parent record with qualifying Child records

Hi All - Looking for some assistance with Query or filter   Issue: I have a child TABLE A with a Direct relationship to PROJECT table. I want to filter TABLE A to ONLY show projects that have NO ch...
General Comment
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi twitchingdog ,

 

Using Table.Group and List.NonNullCOunt:

#"Grouped Rows" = Table.Group(Source, {"ProjectID"}, {{"Count", (t as table)=>List.NonNullCount(t[Status]), type number}}),
    #"Filtered Rows" = Table.SelectRows(#"Grouped Rows", each ([Count] = 0))

You are interested in rows that have zero NonNullCount.

 

Kind regards,

JB