Joining Table Via Union Select with a Filter on Data (Public)

PHOTO EMBED

Thu Sep 02 2021 00:53:32 GMT+0000 (UTC)

Saved by @Darkleech #vba

Table =
FILTER (
    UNION (
        SELECTCOLUMNS ( Tab1, "NewColor", [Color] ),
        SELECTCOLUMNS ( Tab2, "NewColor", [Color] )
    ),
    [NewColor] = "Red"
)
content_copyCOPY

Test

https://stackoverflow.com/questions/64374549/how-to-filter-table-after-dax-union-of-other-tables