Forum Discussion

Arun_BI's avatar
Arun_BI
Helper I
4 years ago

Incorrect Measure Total in Power BI Desktop

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%20Report%20v6.pbix?csf=1&web=1

 

Please clarify my doubt. Thanks in Advance

4 Replies