New Measure, search and return

HI Anonymous,

I'd like to suggest you add a new calculated column to table2 to extract the fact page id:

PageID =
PATHITEM (
    SUBSTITUTE ( [Page], "/", "|" ),
    PATHLENGTH ( SUBSTITUTE ( [Page], "/", "|" ) )
)

Then you can use this field and the date range of the 'week number' to summary records.

Measure =
VAR currDate =
    MAX ( Table[Action Date] )
VAR _list =
    CALCULATETABLE (
        VALUES ( Table[Campaign Page ID] ),
        FILTER ( ALLSELECTED ( Table ), YEAR ( [Action Date] ) = currDate ),
        VALUES ( Table[Action Week] )
    )
RETURN
    CALCULATE (
        SUM ( Table2[Clicks] ),
        FILTER (
            ALLSELECTED ( Table2 ),
            [PageID]
                IN _list
                    && WEEKNUM ( [Date] ) = WEEKNUM ( currDate )
                    && YEAR ( [Date] ) = YEAR ( currDate )
        )
    )

Regards,

Xiaoxin Sheng