Forum Discussion

Durga1's avatar
Durga1
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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-sabeer's avatar
v-sabeer
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

amitchandakplesae share us your emailid so that we can share the PBIX with you