Forum Discussion

Arun_BI's avatar
Arun_BI
Icon for Helper I rankHelper I
4 years ago
Solved

Total Value based on maximum column value instead of sum

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. 

 

 

 

 

 

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

5 Replies

    • Arun_BI's avatar
      Arun_BI
      Icon for Helper I rankHelper I

      Hi Ashish, 

       

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

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

        Hi,

        Write this measure

         

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

         

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