How does matrix column grand total work?

[TanFouc87]

Hi everyone, I'm new with Power BI. I'm practicing with matrix and find that the visual's column grand total is not equal the total I manually calculated. Then I wonder how column grand total of matrix is calculated. Is it simply sum of all others column in matrix or something? 

Thank you in advance

[TanFouc87]

@Kirubs , @PijushRoy 

At the highlighted row, the total in Total columns is not equal the total of other columns.
Then I try filtering only 1 vessel code

It still have this problem. So I wonder if the calculate total mechanism of matric is simply sum all other columns or it can be affected by DAX which is used to calculate columns

[PijushRoy]

Hi @TanFouc87 

Please try to make a table in place of a matrix table, and check
Looks error due to the Calculated Column

Can you please share sample pbix link (remove all sensitive data)

[Kirubs]

Hi, 

Please post the screenshot of the visual in order to check and help. 

[Idrissshatila · Accepted solution]

HEllo @TanFouc87 ,

check this video Why Power BI Totals might seem wrong https://www.youtube.com/watch?v=6rgAkejrup8

[TanFouc87]

This video really help. The cause of my matrix total column's unexpected value is because my DAX. Thank you very much

[PijushRoy]

Hi @TanFouc87 

Can you please share the screenshot of the error you encountered?