Identify and flag Orders based on Null vs Non Null values

[RustyNails]

Hello -

I have a situation where I need to flag Order ID if there is atleast one non-null Detail ID for that order, and say whether it's missing or not. If there is at least one non-null Detail ID, it will be "not missing". Otherwise, it will be "missing". In my screenshot, Calc Column is what I'm trying to create. Any help is welcome. Thanks!

[v-jiascu-msft · Accepted solution]

Hi @RustyNails,

Try this formula, please.

Column =
IF (
    CALCULATE (
        COUNT ( Table1[Detail ID] ),
        ALLEXCEPT ( 'Table1', Table1[Order ID] )
    )
        = 0,
    "Missing",
    "Not Missing"
)

Best Regards,
Dale

[RustyNails]

Bumping this.