Differentiated filter in several tables

[Syndicate_Admin]

Hello, please your help to the following query:

I am consolidating in a new table the unique values of different tables and I need to place a filter to one of these tables to extract the data that matches the text "RESERVE"

Attached code and image of my DAX query.

CONSOLIDATES * to 1 =

FILTER(DISTINCT(UNION(

VALUES('Purchases V2'[NEED*]),

VALUES('SQVI_LIB01'[ID_UNICO]), *** HERE I NEED TO APPLY A FILTER TO EXTRACT THE ID_UNICOS THAT HAVE THE TEXT "RESERVATION" FROM ANOTHER COLUMN *** "

VALUES(SE16N[NEED*]))),

[NEED*]<>BLANK())

[Syndicate_Admin]

Thank you very much, the issue is solved.

[AlB]

Then please mark the answer as the solution and give kudos if suitable

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[AlB · Accepted solution]

You have not specified the name of the "other column" that will be used for the filtering

CONSOLIDATES * to 1 =
FILTER (
    DISTINCT (
        UNION (
            VALUES ( 'Purchases V2'[NEED*] ),
            CALCULATETABLE (
                VALUES ( 'SQVI_LIB01'[ID_UNICO] ),
                'SQVI_LIB01'[The_OTHER_COLUMN] = "RESERVATION"
            ),
            VALUES ( SE16N[NEED*] )
        )
    ),
    [NEED*] <> BLANK ()
)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.