Forum Discussion
Incorrect Row Totals for Measure in Matrix table
We getting incorrect row totals in a table where he have created which uses a measure. A percentage calculation is also needed which uses this field, and so even though the overall values are correct, the total percentage of all values in the table will not be 100% and is skewing calculation
my issue was the row total of the MeasureFTE is incorrect, where he have coloured this font in Red on the GM.Input page. I created MeasureRT to give a decimal value for each team/objective value in the matrix which are also coloured red. The values for the measure are correct, as they should be all total 1 for each team.
MeasureFTE then multiplies MeasureRT by the number of members of each team to try and give an estimation for how much work has been done on an objective based on it’s occupation of the team and how many members they have i.e. in a team of 6 people, a piece of work which took 0.5 or 50% of their time would have a value of 3 in MeasureFTE.
However, the row totals here are not calculating correctly, leading to the graph on the next page using incorrect percentages of the total.
7 Replies
- AnonymousNot applicable
- amitchandakSuper User
It might be a row context issue, you might have change like
measure new = SUMX(SUMMARIZE(Table,Table[Team],"_u",[Measure]),[_u])
Or
measure new = AVERAGRE(SUMMARIZE(Table,Table[Team],"_u",[Measure]),[_u])
- v-sabeerMicrosoft Employee
amitchandakplesae share us your emailid so that we can share the PBIX with you
- v-kelly-msftCommunity Support
Hi Durga1 ,
It should be a context issue,refer to below links:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
https://powerpivotpro.com/2012/03/subtotals-and-grand-totals-that-add-up-correctly/
Best Regards,
KellyDid I answer your question? Mark my post as a solution! - Durga1Microsoft EmployeeHello Team, Can anyone please provide us the solution for the above issue that would be very helpful to us. Thanks, Durga Prasad.