Active connections

Hi keivan ,

If you want to get active connection id, you can create a measure to filter your id list.

Measure = 
VAR _LASTDATE =
    CALCULATE (
        MAX ( Consents[valid_until] ),
        FILTER (
            Consents,
            Consents[connection_id] = MAX ( Connections[connection_id] )
        )
    )
RETURN
    IF ( _LASTDATE >= TODAY (), 1, 0 )

Add this measure into visual level filter and set it to show items when value =1.

Result is as below.

According to your statement, I think your requirement is based on your data model. Please share a sample file with me and show me a screenshot with the result you want.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.