MATRIX VIEW WRONG COLUMN TOTAL

[saturn051]

HI, I am using version: 2.68.5432.841 64-bit (April 2019). I get a wrong column total while using the matrix view.

1-cells inside the matrix sum up to 2196

2-column total is 2252

3-The error is discovered exporting the view to excel, where the total goes back to the correct value (2196)

Can anybody help?

[Anonymous · Accepted solution]

Totals are figures where there are less ( or no ) filters applied. Each figure you see is calculated independantly of each other and the fact that the totals add up to the sum of the figures before it is happenstance. So the total you see is correct, just not what you'd expect.  Without seeing more of the data, you can use something like:

Measure =
SUMX ( 
    VALUES( what you want to sum),
    CALCULATE (
          [Your Measure Here]
)
)