If any related object fullfils condition

[Anonymous]

Hello all

get example.pibx here

I have table Panels and Table Slots. Every Panel can have multiple Slots.

I need to mark the panels where no slot is active. (Active means in this case hase the EndDate in the future).

So goal is a column in panels that says true/false for above condition.

Many thanks

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Create below calculated column in Panels table, which returns true if the panels has no slot is active, otherwise returns false.

column =
IF (
    CALCULATE (
        COUNT ( Slots[active] ),
        FILTER ( Slots, Slots[active] = 1 && Slots[Panels_ID] = EARLIER ( Panels[ID] ) )
    ) > 0,
    FALSE (),
    TRUE ()
)

Best regards,

Yuliana Gu