SUM of max by category and rows with value

[nakulprajapati2]

I need to calculate the sum of Maximum resource used on that day. 

I am using the below formula but doesnt show me what the values are shown in excel. 

SUM of Max Working = 
SUMX (
    SUMMARIZE ( Sheet1,Sheet1[Date], Sheet1[Resource Name],Sheet1[Activity Name] ),
    CALCULATE ( MAX( ( Sheet1[Value] ) )
))

I have been struggling with this for a very long time now, and thought to finally seek help from the experts. 

[v-yadongf-msft · Accepted solution]

Hi @nakulprajapati2 ,

This is my test table. Before you import the data, please add an index column named ID in Excel or Power Query.

Then please try following DAX to create a new column:

Column = IF(
    'Table'[Activity me] = "Activity1",
    CALCULATE(
        SUM('Table'[value]),
        FILTER('Table','Table'[ID] >= EARLIER('Table'[ID]) && 
                       'Table'[ID] <= EARLIER('Table'[ID])+7)
        )
        )

Create a table visual like below:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.