Forum Discussion
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
Helper I
amitchandak do you know the solution for the problem stated above?
- Ashish_Mathur
Super User
Hi,
Share the link from where i can download your PBI file.
- Arun_BI
Helper I
Hi Ashish,
Please find the link. Let me know if it doesn't works
- Ashish_Mathur
Super User
Hi,
Write this measure
Measure 2 = MAXX(VALUES('CIC FTE'[Project Name]),[Actual Hours(By Projectname)])
- Arun_BI
Helper I
Thanks Ashish for the timely help. The measure works perfectly fine.