Total Value based on maximum column value instead of sum

[Arun_BI]

I have the following data coming from the below measure which splits the no of weeks based on the project start and end date.

Measure:

Actual weekly duration (By Month) = CALCULATE(SUMX(SUMMARIZE(FILTER(CROSSJOIN('FTE','Datetable'),'Datetable'[Date] >=(' FTE'[Start date]) && 'Datetable'[Date]<=('FTE'[End date])),'FTE'[Project Name],Datetable[Date],'FTE'[Actual Project Duration(In weeks)],'FTE'[Start date],'FTE'[End date]),DIVIDE('FTE'[Actual Project Duration(In weeks)],DATEDIFF('FTE'[Start date],'FTE'[End date],DAY)+1)))

Output:

Question: Now my measure sums up the no of weeks (values) for each month for each staff as shown in the above image. Instead of summing up the total, I need to show the maximum value for each month for eg For Anbu for Feb it is 3.91 and March 4.33 and for Apr 4.19 . Any help is much appreciated. 

[Arun_BI · Accepted solution]

Thanks Ashish for the timely help. The measure works perfectly fine. 

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Arun_BI]

Hi Ashish, 

Please find the link. Let me know if it doesn't works 

[Ashish_Mathur]

Hi,

Write this measure

Measure 2 = MAXX(VALUES('CIC FTE'[Project Name]),[Actual Hours(By Projectname)])

[Arun_BI]

@amitchandak do you know the solution for the problem stated above?