Direct query - relationship with multiple columns

Hi kchojnowski,

You could create below measures:

count for activation =
CALCULATE (
    COUNT ( StatusTable[Date Activation] ),
    FILTER (
        ALL ( StatusTable ),
        StatusTable[Date Activation] = SELECTEDVALUE ( DateTable[Dates] )
    )
)

count for deactivation =
CALCULATE (
    COUNT ( StatusTable[Date deactivation] ),
    FILTER (
        ALL ( StatusTable ),
        StatusTable[Date deactivation] = SELECTEDVALUE ( DateTable[Dates] )
    )
)

Add DateTable[Dates] and above two measures into a table visual.

Best regards,

Yuliana Gu

Thanks for reply! I have made something like this and it worked:

CALCULATE(COUNT(<table[columnname]>),USERELATIONSHIP(table[mydate];calendar[date]))

Ofc before i have made relationship between date activation - calendard date and inactive relationship between date closed and calendar date :)