Incorrect Measure Total in Power BI Desktop

[Arun_BI]

Hi Team,

I have the following data coming from the below measure which splits the no of weeks based on the project start and end date and takes the maximum week numbers across months. The measure works fine for individual staff members but the total value of the measure seems to be wrong. Please refer to the below image.

Output:  I need to show the maximum value for each month for eg For Feb it is 3.93 and March 4.35 and Apr 4.29 . 

File Link:

Please find the link for the PBIX file: https://curtin-my.sharepoint.com/:u:/r/personal/286885h_curtin_edu_au/Documents/Power%20BI/Timelog%2...

Please clarify my doubt. Thanks in Advance

[isabella]

Hi @Arun_BI 

It seems that the download link you provided is private, maybe you can adjust the permissions of this file so that we can download it

Best Regards,

Community Support Team _Isabella

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

[Ashish_Mathur]

That takes me to a log-in page

[Arun_BI]

Please try this link: https://curtin-my.sharepoint.com/:f:/g/personal/286885h_curtin_edu_au/EpScj3PQRKdKuIVDHIWXNJgBHEP_zb...

[Ashish_Mathur]

I have already answered this question a few days ago.  Please refer to that post.