Apply filter in Union Table

Hi pmadam ,

According to your statement, I think "UNIONTABLE-BKM-NDC" is an UNION table by dax. [_APPR DATE CHECK] should be a calculated column to return flag based on some conditions.

You can create a virtual table and filter it.

UNIONTABLE-BKM-NDC =
VAR _BASIC_UNION =
    UNION ( 'Table1', 'Table2' )
VAR _ADD_APPR_DATE_CHECK =
    ADDCOLUMNS (
        _BASIC_UNION,
        "_APPR DATE CHECK",
            IF (
                [AddedDate]
                    = MINX (
                        FILTER ( _BASIC_UNION, [OrderNumber] = EARLIER ( [OrderNumber] ) ),
                        [AddedDate]
                    ),
                "OLDEST DATE",
                "NOT OLDEST DATE"
            )
    )
VAR _FILTER =
    FILTER ( _ADD_APPR_DATE_CHECK, [_APPR DATE CHECK] <> "NOT OLDEST DATE" )
RETURN
    _FILTER

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.