Summarize column and filter 2 tables

[Elisa112]

Hi Experts

I am having an issue figuring out how to summarise and filter columns from different tables which are connected appropriately via one to many relationships.  So far I have managed to figure out I need a to summarise and filter two tables, I am trying to bring back 2 dates, 1 from the meeting table (Engagement type) and 1 from the Assess table. Conditions active customers (status from customer table), Assess types "new" and "first" from Assess table. 

My dax so far is below but I am getting errors on this:

Summary_Table2 =

SUMMARIZECOLUMNS (

    'Cust[C_ID],

    'Manager'[M_Name],

    "Customer Meeting",

        CALCULATE (

            MIN ( 'Appointments'[Meeting Date]),

            'Appointments'[Type] = "Engagement"),

    "Assess",

        CALCULATE (

            MIN ('Assess'[Assessment Date]),

           FILTER('Assess',

           'Assess'[C_ID] = SELECTEDVALUE('Assess'[C_ID]) &&

                 ('Assess'[Assessment Type] = "New") && ('Assess'[Assessment Stage] = "First")

           ),

Errors so far = Argument 3 in Calculate function required (not sure what this means)

From 3 Tables: Cust/Meetings/Assess  all joined to Meetings and Assess are joined to Customer on C_ID via one-to-many relationships. 

I am trying return a table that looks like this:

Cust_Meeting   C_ID            M_Name         Assess      

12 June             001              KMP                15 June

15 June             002              PNN                19 June

Any help appreciated, thanks in advance.

[Elisa112]

thanks so much

[MFelix · Accepted solution]

Hi @Elisa112 ,

Believe that you are missing some parenteses and you have one comma at the end try this changes:

Summary_Table2 =
SUMMARIZECOLUMNS (
    "Customer_ID", 'Cust'[C_ID],
    "Manager", 'Manager'[M_Name],
    "Customer Meeting",
        CALCULATE (
            MIN ( 'Appointments'[Meeting Date] ),
            'Appointments'[Type] = "Engagement"
        ),
    "Assess",
        CALCULATE (
            MIN ( 'Assess'[Assessment Date] ),
            FILTER (
                'Assess',
                'Assess'[C_ID] = SELECTEDVALUE ( 'Assess'[C_ID] )
                    && ( 'Assess'[Assessment Type] = "New" )
                    && ( 'Assess'[Assessment Stage] = "First" )
            )
        )
)