topic Re: Number of parents without children in DAX Commands and Tips

Number of parents without children

Anonymous — Sat, 18 Apr 2020 03:15:29 GMT

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

Re: Number of parents without children

Greg_Deckler — Sat, 18 Apr 2020 03:50:53 GMT

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

Re: Number of parents without children

Mariusz — Sat, 18 Apr 2020 08:48:04 GMT

Hi Anonymous

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