The total in matrix is not correct

[Avivek]

The total in the matrix is not showing the correct value, however when exported in excel it shows the correct value.

So in the image you can see the value against the person is shown as 5275 but the total shows 6575. Any idea why is this so?

[Anonymous]

Hi @Avivek ,

Whether the field "Sales Amount" is from the returned values of a measure? You can refer the contents in following links to update the formula of your measure to get a correct total value.

Power BI: Totals Incorrect

Wrong Grand Totals in Power BI

In addition, you can also provide some sample data which is from the applied fields on Matrix and the formula of measure "Sales Amount", later we will help you correct it. Thank you.

Best Regards

Rena

[amitchandak]

@Avivek , can you share the formula.

[rveerasamy]

@amitchandak 

Sales Amount = IF(SELECTEDVALUE('REPORTING CURRENCY'[REPORTING CURRENCY],"Base")="Base",sum(SALES[BASE AMOUNT]),sum(SALES[ORIGINAL AMOUNT]))

[Anonymous · Accepted solution]

Hi @rveerasamy ,

Please try to create a new measure as below, then drag the new created measure onto Matrix to replace the measure Sales Amount:

Measure =
SUMX (
    VALUES ( 'SALES'[PARENT ACC NAME] ),
    SUMX ( VALUES ( 'SALES'[FULL NAME] ), [Sales Amount ] )
)

If the above method is not working, please provide some sample data which is from the applied fields on Matrix and the table structures in your data model if the matrix involves multiple tables data. Thank you.

Best Regards

Rena