Number of parents without children

[jfattic]

What formula can I use to count the number of parents that have zero children?

I have a table of Orders that have a related table of child Items. I need to know how many Orders have no associated Items. (Orders without Items are an error that we have to look out for.)

[Greg_Deckler]

I wrote that once: https://community.powerbi.com/t5/Quick-Measures-Gallery/Childless/m-p/625084#M305

[Mariusz · Accepted solution]

Hi @jfattic 

You can add a Measure  like below

Count of Orders with no Items  = 
SUMX( 
    Orders,
    CALCULATE( INT( ISEMPTY( OrderItems ) ) )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn