Hello everyone, Can you please help to tell:How to create measure to: Sum Table2[Clicks] for certain Unique [Table1]Campaign Page ID are cointained in Table2[Page] under certain [Table1]Action Week?e.g. Sum Clicks for all Unique [Table1]Campaign Page ID in "Week10", or Sum Clicks for all Unique IDs in "Update Copy" Table2: Thanks.H

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

New Measure, search and return | Microsoft Fabric Community

Forum Discussion

Related content

Measure returning incorrect value

Measure is returning BLANK

DAX Measure Returning Incorrect Results

Create Measure to Return Highest Value

Slicer Search Bar