Subtotal showing wrong in matrix table

[NISHA_S]

Above mentioned visual contain a column which is calcualting average of value...Average calcualtion are correct...But Its row level subtotal showing is not correct....17.33+17.57=34.9 is neede...But showing like 17.36...Why it is happening like this..Any solution for this?

[Jihwan_Kim · Accepted solution]

Hi, @NISHA_S 

Please try the below.

Write one more measure like below.

Total Fix =
SUMX ( VALUES ( [System Type Column] ), [Your Avg Measure] )

And put the above measure into the visualization.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[jdeveaux]

Hello,

It is calculating the average on the total categorie of Concrete. It does not sum up the average...

The solution is to manually set up your totals with custom measures and to remove standard totals.