Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How does matrix column grand total work?

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

Need Help
Tutorial Requests

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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

       

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Anonymous 

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



  • Kirubs's avatar
    Kirubs
    Frequent Visitor
    2 years ago

    Hi, 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      PijushRoy
      Community Champion
      2 years ago

      Hi Anonymous 

      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)