Matrix Totals are not correct

[Begbie]

Hello good people of the PBI community.

I need some help please to understand why my matrix visual is showing incorrect totals 🤔

I have a relatively simple matrix of the rows made up of:

Portfolio

   Platform

      Product

I then have 3 columns:

Average Days Uncompliant

Daily Cost

Total Cost

The total cost column that is the one is showing incorrect and is a measure of average days * daily cost. Whilst the figures are correct within the product rows, when it gets to platform & portfolio level, the numbers are incorrect and I've been racking my brain over this 😔

The daily cost is a measure of 

Daily Cost = CALCULATE(SUM(BeaconChecksCostDB[AffectedResourcesPotentialSavings]))

The average days compliant is another measure of 

Average Days Uncompliant = AVERAGEX(VALUES(Products[Product Name]),[# Days Uncompliant])

And the measure of # days uncompliant is a datediff calculation with a switch statement.

Any help or pointers is greatly received as always.

Thank you

[v-zhangti · Accepted solution]

Hi, @Begbie 

There is no error in the calculation of total cost, but the Average column has decimals omitted.

As shown in the figure, this is an unindented decimal. The calculation is correct.

This is the data after the decimal point is omitted. 2.06*145<>298.44, but 145 itself is not 145.

Best Regards,

Community Support Team _Charlotte

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

[Begbie]

Thank you for taking the time to reply and show the working out.

I'm embarrased to say, you are totally correct. I adjusted my report to show the decimal places in the average day and now the figures all tie up 😳